Re: Show only certain records in a query by date and time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Damian! I had thought about those 2 at one time but for some reason
couldn't figure out that it would work...but seems to work like I need it
to.

Linda

"Damian S" <DamianS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5FC01027-DFC2-411D-A3F3-61F9475F7476@xxxxxxxxxxxxxxxx
Hi Linda,

No need to use dateadd()

You could just use is null or >= Date()

However, for your time problem, you should probably use Now() which
includes
date and time. ie: is null or >= Now()

Hope that gets you moving in the right direction.

Damian.

"Linda RQ" wrote:

Access 2003. I'm sorry to be asking so many questions today but I hope
they
help someone else too and I have been working on only access since 7 this
morning. I have been spending a lot of time learning how to find my own
answers using Jeff Conrad's favorite sites, and the help file in access
and
I only ask if I have spent more than an hour hunting. I still don't
quite
know how to ask some questions yet I guess.

I have a query with a dtt field that has therapy end dates, I have both
date
and time in the field. I want my query to show records that do not have
an
expiration date in the field and also records that have expiration dates
that haven't occurred yet. I have end dates of
10/20/06,10/21/06,10/22/06,10/23/06,10/24/06, 10/25/06. It sort of works
because the dates 10/20, 10/21,10/22 and 10/23 do not show up but the
10/24
record still shows and it should have expired at 2:14 pm on 10/24 (today)
and since it's 7:35 pm now I was thinking it shouldn't be showing up.
This
leads me to believe that I need to put in something for the time factor
in
my expression but I can't seem to find anything so far to include the
days,
minutes and hours.

The other issue is that I completely am using the wrong expression but I
was
pretty excited that it worked almost as expected.

Is Null Or >=DateAdd("d",0,Date())

Thanks,

Linda





.

Relevant Pages

  • Re: Text Box Help
    ... Take a look at conditional formatting in the Help file. ... I have three fields that holds expiration dates in a text box. ... populated in a form by way of a query. ...
    (comp.databases.ms-access)
  • Re: query for tag renewal
    ... You will see all records with an expiration date in that range. ... The above criteria gave me all tagexpirations in the table. ... When you make a query based on the table containing ExpDate, ...
    (microsoft.public.access.queries)
  • Re: an easy one
    ... Is this not an access newsgroup? ... The help file would have told you runquery is not a legal action. ... I'm rusty and actually have never ran a query from code. ... There is an Access help and a VBA help. ...
    (comp.databases.ms-access)
  • RE: Automatically Delete Duplicated Data in Table
    ... The second half of the help file went OK also and a new ... table was created minus all the duplicates. ... Create a new query based on the Original table containing duplicates. ... > click Append Query. ...
    (microsoft.public.access.queries)
  • Re: Dlookup - autofill control based on combo box choice
    ... the expiration date of the current term, why use a query and a DLookup? ... > I also have a query with a calculated field ... > instantly displays the value calculated in [Expr1] in my query. ...
    (microsoft.public.access.forms)