Query based on empty field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am still learning / self teaching myself Access. I need to run a query that
shows me the ETA of parts. My thought was to run a query that showed all
parts that did not have a Receved Date. Is that correct? If so, what do I put
in the query for criteria under Received Date so it shows only those with no
info input??
 
I'm not sure how displaying fields with no data would givr you the ETA of
parts. Butif your trying to ruun query which with no data, then under
criteria enter IS NULL.
 
Back
Top