Need help with building a formular

  • Thread starter Thread starter Kerstin
  • Start date Start date
K

Kerstin

I am trying to built a formular in the expression
builder. Basically I want my whole table to show in this
query.
With the exception of some data:

In one field the formular should say, dont show that data,
when this field contains information. Is there such a
formular like in Excel where you can say, If field is not
empty, dont show it? Or do I have to be specific - like
some of the fields have a X in it.

Thanks for the help!
 
Kerstin

Not sure I completely understand... If you open a query in design mode, you
can enter criteria, and so exclude/include rows. Does that help?
 
I think what you're trying to do is the following:


DisplayFlag: IIF(Field Is Not Null,"Hide","Display")

put the "display" in the criteria under this DisplayFlag
field you create in the query.

I think that will get you what you need... or at least
some variation of the above will work.


Hope that helps.
 
Back
Top