Re: Show records for Today

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

First, DATE is a reserved word. Please rename your field.

If you are storing a date, the I would do me.SomeField = Date(), not
Now().



--
Rick B



"Aminov" <Aminov@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26A24DA1-02EB-4CFB-84E8-1A1C9AC931A1@xxxxxxxxxxxxxxxx
Hello experts,

This should be simple but it's driving me crazy!

I have a Tickets table one of it's field is [Date] it works as a time
stamp
it's formated to (Long date)

I also have a form with a command button that stamps the time:
me.date=now()

Now in a query I only want to show records that matches today's date only
date() but I always get no records. I think its a problem with Time
because
when I enter today's date manually it appears in the query!

What should I do? can I perform formatting with command button? or what
should I do?

Thanks,



.

Relevant Pages

  • Re: Show records for Today
    ... I also have a form with a command button that stamps the time: ... Now in a query I only want to show records that matches today's date only ... can I perform formatting with command button? ...
    (microsoft.public.access.reports)
  • Re: Show records for Today
    ... You can use one of the following as criteria ... I also have a form with a command button that stamps the time: ... Now in a query I only want to show records that matches today's date only ... can I perform formatting with command button? ...
    (microsoft.public.access.reports)
  • Re: MacBook Pro with a new weird AWFUL bug
    ... command-z after every alignement command. ... If you have a Table Style applied, all formatting in the table is under ... publisher of the font and the date and version number of the font file). ... Word and Word for Macintosh. ...
    (microsoft.public.mac.office.word)
  • Re: Counting Concurrent timed events
    ... When you make a command button, Access gives it an ambiguous name like "Command2" ... ... then compile your code ... Exit Sub ... what you need to be able to do is replace the SQL using a different date before you run the query that uses it. ...
    (microsoft.public.access.queries)
  • Re: MacBook Pro with a new weird AWFUL bug
    ... You have left "Automatically update style" turned on. ... command-z after every alignement command. ... If you have a Table Style applied, all formatting in the table is under ... publisher of the font and the date and version number of the font file). ...
    (microsoft.public.mac.office.word)