Is there a way to tell a query not to print when a record has no data? (blank/no text)
I am sure I have seen this somewhere but I can't seem to find it right now.
Is there a way to tell a query not to print when a record has no data? (blank/no text)
I am sure I have seen this somewhere but I can't seem to find it right now.
What do you mean by "not to print"? A little more info would be helpful. What is the context of the issue?
If you're using a report, you can use the report's event (I think it's called):
'On No Data' or something like that.
The final product will be a report but I would like to clear up the problem in the query that the report is based upon so that I can create another report in the future (based upon this query) and have the problem already solved.
The query has several empty (blank/no text) records. I would prefer that the query skip (not print) these and go on to the next record. This would, in turn, cause the report(s) to not have blank areas.
All I can find in "help" is how to cancel printing when records are blank. I don't want the printing to stop. I just want to skip these blank records and continue printing the records that are not blank.
I am thinking that something like "NoData NEXT" would do it but I am sure that this is not the proper syntax.
Last edited by Bear; 08-04-2011 at 12:45 PM. Reason: add info
put this
NOT ISNULL
in the criteria of your query. It will only report items that have data.