Filter query so the only records displayed have 4 null fields

  • Thread starter Thread starter Astrid
  • Start date Start date
A

Astrid

Is this possible, and if so how?

I have a query which pulls together purchase order (PO) numbers for 4
different categories (and fields) in the same table - Flights, Transport,
Hotels and Miscellaneous.

I would like to be able to filter these results so that it only displays
records which have no records (are blank) for all of the relevant fields
(e.g. FlightPO = null, TransportPO = null, HotelPO = null and MiscPO = null).

I can filter for null fields using the criteria 'Is Null', but can I filter
so that it brings up the results for 'If [FlightPO] Is Null AND if
[TransportPO] Is Null AND if [HotelPO] is Null AND [MiscPO] Is Null....."

Am I on the right lines? Where do I enter the code in the query? and what
should the code be?

All help will be greatly appreciated.
 
In the grid, have each fields in the grid and add the criteria:

Is Null


under each of them, at the criteria line.



Vanderghast, Access MVP
 
Back
Top