check if a product is missing?

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
 
K

Klatuu

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.
 
A

Arvin Meyer [MVP]

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.
 
J

jo

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
 
D

Douglas J. Steele

DateDiff("h", 8, Now())

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)
 
J

jo

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
 
D

Douglas J. Steele

Sorry, my typo. I meant DateAdd, not DateDiff.

Glad you got it figured out.
 
Top