check if a product is missing?

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

Glad you got it figured out.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"jo" <jo.DeleteThis@discussions.microsoft.com> wrote in message
news:A3BFE2B1-528F-4E93-BC1E-416DE453699E@microsoft.com...
> HI Doug I found this does the trick: >DateAdd("h",-8,Now())
> Thanks for you help
> Jo
>
> "Douglas J. Steele" wrote:
>
>> What's the SQL of your query?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "jo" <jo.DeleteThis@discussions.microsoft.com> wrote in message
>> news:C5D3CE13-2371-473C-96B7-C1135237E868@microsoft.com...
>> > 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
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> > DateDiff("h", 8, Now())
>> >>
>> >> --
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no private e-mails, please)
>> >>
>> >>
>> >> "jo" <jo.DeleteThis@discussions.microsoft.com> wrote in message
>> >> news:CE58B700-B3E6-4B8F-8FFF-39AA7D223ED5@microsoft.com...
>> >> > 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
>> >> >
>> >> > "Arvin Meyer [MVP]" wrote:
>> >> >
>> >> >> 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.
>> >> >> --
>> >> >> Arvin Meyer, MCP, MVP
>> >> >> http://www.datastrat.com
>> >> >> http://www.mvps.org/access
>> >> >> http://www.accessmvp.com
>> >> >>
>> >> >>
>> >> >> "jo" <jo.DeleteThis@discussions.microsoft.com> wrote in message
>> >> >> news:9C229C04-5F39-4C66-A090-4A71B9B8C4B8@microsoft.com...
>> >> >> > 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
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>

"jo" <jo.RemoveThis@discussions.microsoft.com> escreveu na mensagem
news:A3BFE2B1-528F-4E93-BC1E-416DE453699E@microsoft.com...
> HI Doug I found this does the trick: >DateAdd("h",-8,Now())
> Thanks for you help
> Jo
>
> "Douglas J. Steele" wrote:
>
>> What's the SQL of your query?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "jo" <jo.RemoveThis@discussions.microsoft.com> wrote in message
>> news:C5D3CE13-2371-473C-96B7-C1135237E868@microsoft.com...
>> > 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
>> >
>> > "Douglas J. Steele" wrote:
>> >
>> >> > DateDiff("h", 8, Now())
>> >>
>> >> --
>> >> Doug Steele, Microsoft Access MVP
>> >> http://I.Am/DougSteele
>> >> (no private e-mails, please)
>> >>
>> >>
>> >> "jo" <jo.RemoveThis@discussions.microsoft.com> wrote in message
>> >> news:CE58B700-B3E6-4B8F-8FFF-39AA7D223ED5@microsoft.com...
>> >> > 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
>> >> >
>> >> > "Arvin Meyer [MVP]" wrote:
>> >> >
>> >> >> 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.
>> >> >> --
>> >> >> Arvin Meyer, MCP, MVP
>> >> >> http://www.datastrat.com
>> >> >> http://www.mvps.org/access
>> >> >> http://www.accessmvp.com
>> >> >>
>> >> >>
>> >> >> "jo" <jo.RemoveThis@discussions.microsoft.com> wrote in message
>> >> >> news:9C229C04-5F39-4C66-A090-4A71B9B8C4B8@microsoft.com...
>> >> >> > 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
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >> .
>> >> >>
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>
>