EzGoingKev
Registered User.
- Local time
- Today, 15:31
- Joined
- Nov 8, 2019
- Messages
- 178
I needed to filter some data in a query so I added a field titled "ProductDescription" that has the following data in it:
Turbocharger
Turbocharger Mount
Supercharger
And some empty cells
I used NOT IN ("Turbocharger Mount") and it brought back data where the cell contained Turbocharger and Supercharger but dropped the empty fields.
Why would it drop the empty cells?
ETA - To get the result I wanted I used IS NULL OR NOT IN ("Turbocharger Mount").
Turbocharger
Turbocharger Mount
Supercharger
And some empty cells
I used NOT IN ("Turbocharger Mount") and it brought back data where the cell contained Turbocharger and Supercharger but dropped the empty fields.
Why would it drop the empty cells?
ETA - To get the result I wanted I used IS NULL OR NOT IN ("Turbocharger Mount").