empty date field query

[Techknownothing]

This is not a repost but a slight variation on a post from a few days
ago.
I have a main form that populates tblCUSTOMER with many different
customers.
That form has a subform that populates tblHISTORY tracking the
purchases of each individual customer by date. Both tables are linked
by AUTO ID.
Sales that are not yet finalized are entered into tblHistory without a
date.
I want to run a query that pulls only the entries that do not have a
date from
tblHISTORY for a particular set of customers.
Any assistance is much appreciated

JC

 

[Douglas J. Steele]

If there's no data in a date field, that implies it's Null (you can't store
spaces in a date field, only numbers). Simply put "IS NULL" as the criteria.

 

[Techknownothing]

thank you!

JC

If there's no data in a date field, that implies it's Null (you can't store
spaces in a date field, only numbers). Simply put "IS NULL" as the criteria.