Selecting Certain Records?

[hi there]

Hi everyone,

i need to build a query that will exclude records if a field within that record is null. basically if the record doesn't contain data for a particular field then i don't want the query (and consequently the report) to display that record. for example, i have 50 records and only 35 of them contain values for a field named "requirements." in the corresponding query (and report), i only want to display the 35 records. is there some easy VBA code i could use and if so where would i put it?

thanks

 

[Rich]

Puy Not Is Null in the criteria section of the relevant query field

 

[hi there]

duuuh, i can't believe i didn't remember that. thanks rich. for some reason i was thinking i needed to build one query with multiple criteria to generate multiple reports, but it's much easier to use a separate query for each report.

thanks again, rich.