Text Field is blank in a Query

D

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.
 
D

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.
 
J

John W. Vinson

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

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?
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is Not Null Doesn't work in my query 5
Comparing data between a field and the values in a query 1
Parent / Child form/subform 1
Automaticaly populate field 3
In access if form value is yes display next field. 1
Pull Down Menu 1
After Update Confusion 7
Total number of days 1

Top