Text Field is blank in a Query

[Denise]

I have a field called Training Topic 01, Training Topic 02, etc.

If one of those fields is blank, I do not want to include that field in my
report.

What do I put in the criteria?

Thanks.

 

[golfinray]

Is not null

 

[Denise]

Sorry. I should of said if the field is blank do not show in the report.

If the field has text in it, then it needs to go into the report.

 

[John W. Vinson]

I have a field called Training Topic 01, Training Topic 02, etc.

Are these *FIELDS* in a table?

If so your table structure is wrong: you're "committing spreadsheet". If you
have up through Training Topic 10, what will you do when there are eleven
topics?

If one of those fields is blank, I do not want to include that field in my
report.

What do I put in the criteria?

Criteria work by either selecting an entire record... or not selecting it. If
these are all fields in the same record, then criteria on a query will not
help. If the field is NULL it will, of course, show as blank on the report; if
you want to also suppress the label of the textbox, you'll need some VBA code
in the section's Format event.