Filter query so the only records displayed have 4 null fields

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

 

[Michel Walsh]

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

 

[Astrid]

Wow! That was easier than I thought!

Thanks Michel x