Trying this Query unsuccessfully

[Brachole]

I try writing this Query but not getting the results I'm looking for. Have an Access Table wit hthe following Fields:

- PRS801 (Text Data Type)
- SerialNumber (Text Data Type
- DateReceived (DateTime Data Type)
- DateShipped (DateTime Data Type)

I want to list all serial numbers that shipped in 2008 without being received:

SELECT PRS801SerialNumber, DateShipped, DateReceived
FROM RMA_Number
WHERE PRS801 = "Yes" AND (DatePart('yyyy',DateShipped)=2008) AND (DateReceived="");

If the equipment was never sent, then the Field for DateReceived is blank. This returns 0 which isn't correct.

[chazzy]

maybe DateReceived IS NULL instead of = "" ?

[Brachole]

Beautiful...thanks a bunch!