Text Field is blank in a Query

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.


--
Denise B.

Is not null
--
Milton Purdy
ACCESS
State of Arkansas


"Denise" wrote:

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.


--
Denise B.

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.


--
Denise B.


"golfinray" wrote:

Is not null
--
Milton Purdy
ACCESS
State of Arkansas


"Denise" wrote:

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.


--
Denise B.

On Thu, 28 Jan 2010 05:09:01 -0800, Denise
wrote:

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

John W. Vinson [MVP]