check if a product is missing?

  • Thread starter Thread starter jo
  • Start date Start date
J

jo

hi i would a query that can tell me if a certain product has not been entered
in the last 8 hours. e.g Below shows that PC3 is missing, can a query flag up
the missing product (PC3)?
FieldName
Channel
PC6
PC4
PC2
PC5
 
You haven't included enough info to answer your question.
First, how do you know whether a product has been entered in the last 8 hours?
Tell us a bit about your data and what it means.
 
Yes, as a matter of fact there is a built in wizard called the Find
Unmatched Query Wizard.

You will need a table with all the products, joined to the table with the
possible missing products. The wizard will walk you through all of that.
 
Thanks that works perfect just what i wanted. Just one question in my query i
have it looking for data in the last 15 days with this expression: >Date()-15
but also need to another query to look in the last 8 hours do you know how to
write this please?
Thanks Jo
 
DateDiff("h", 8, Now())

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)
 
Hi Doug that doesn't seem to be working its showing all products have not
been done instead of product? en ideas wot I may be doing wrong?
Jo
 
Back
Top