(Msg. 1) Posted: Fri Oct 23, 2009 5:25 am
Post subject: check if a product is missing? Archived from groups: microsoft>public>access (more info?)
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
(Msg. 2) Posted: Fri Oct 23, 2009 6:57 am
Post subject: RE: check if a product is missing? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
--
Dave Hargis, Microsoft Access MVP
"jo" wrote:
> 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
>
>
(Msg. 3) Posted: Fri Oct 23, 2009 10:01 am
Post subject: Re: check if a product is missing? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Yes, as a matter of fact there is a built in wizard called the Find
Unmatched Query Wizard.
"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
>
>
(Msg. 4) Posted: Sat Oct 24, 2009 2:56 am
Post subject: Re: check if a product is missing? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.TakeThisOut@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
> >
> >
>
>
> .
>
(Msg. 5) Posted: Sat Oct 24, 2009 7:55 am
Post subject: Re: check if a product is missing? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> DateDiff("h", 8, Now())
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"jo" <jo.TakeThisOut@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.TakeThisOut@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
>> >
>> >
>>
>>
>> .
>>
(Msg. 6) Posted: Sat Oct 24, 2009 9:32 am
Post subject: Re: check if a product is missing? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.TakeThisOut@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.TakeThisOut@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
> >> >
> >> >
> >>
> >>
> >> .
> >>
>
>
> .
>
(Msg. 7) Posted: Sat Oct 24, 2009 5:24 pm
Post subject: Re: check if a product is missing? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
>> >> >
>> >> >
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>
(Msg. 8) Posted: Sun Oct 25, 2009 5:33 am
Post subject: Re: check if a product is missing? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >> .
> >> >>
> >>
> >>
> >> .
> >>
>
>
> .
>
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other