Query

[Krista]

I have created a query that will ask for a Quote Number and return the
results once entered. I have some fields that will be blank. Is there
something I can do so that any blank fields do not show up in my query? I
would guess that it would be some kind of "IF" statement. (If the field is
blank, do not include it. If there is data in the field, show it.)

 

[Douglas J. Steele]

A query is going to return as many fields as you included in it. It doesn't
matter whether or not those fields contain values.

Since you should never be presented the results of a query directly to the
user (just as you should never display tables to users), you should be able
to conceal the empty fields in the form or report.