Selection for report

[Guest]

An easy question....I know :
I have a report, just taking fields from 1 table. I want to make a selecton,
or filter out so that only the record where Text = "" (space) comes out on
the report.
How do I do this in an easy way ?

As you can see I am not som familiar with all comands....yet.....

Thank you !

 

[Guest]

In the design view of the query you use for the report insert this into the
criteria row of the grid for the field --
Like " "

 

[Van T. Dinh]

Easy question ... but not sure of what you need ...

You posted

Text = ""

that means the value of the Field "Text" is an empty String but then you had
(Space)

after which is a definite character, not an empty String?

This is not efficient (until we know what you want and what is actually
store in your Table which can be Null rather than empty String) but if you
want to select all records where the value for the Field "Text" is white
space (including Null and empty String), use the criterion:

.... WHERE Len(Trim([Text] & "")) = 0

in the Query being used as the RecordSource for the Report.

 

[Guest]

Than you,,,,I think I understand what you mean.....

But....to be more exact (maybe my language makes it difficult).....I only
want those records where the field "text" is empty to show at the report. And
I just can't understand where and how I put the query you suggested !?!

 

[Guest]

Use the query as the Record Source for the report.