If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query based on empty field
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?? |
#2
|
|||
|
|||
Query based on empty field
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. "Breezy" wrote: 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?? |
Thread Tools | |
Display Modes | |
|
|