Newb Query Question

[Cardinal]

I am using Access 2003. I am trying to create a query that returns
only records for todays date. I've tried now() and date()
unsuccessfully. Can someone give me hint on what to try? Thank you.

 

[George]

Dear friend,

Does your table has a date field which is automatically recorded using the
current date or time?

If there is such a field and the recording date is recorded then use (in
your query) the critiria under tha field =date().

If there is such a field and the recording date and the time is recorded then
using an empty column in your query type:

MyDate: CDate(Int([YourDateField])) and use the same criteria as mentioned
above.

GeorgeCY


Ο χÏήστης "Cardinal" έγγÏαψε:

 

[John Spencer]

Sounds as if your date field also contains a time (other than midnight). So
to get any matches you are going to need to get the range of dates plus times
for the current date.

Field: [Recording Date]
Criteria: >=Date and < DateAdd("d",1, Date())

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Dear friend,

Does your table has a date field which is automatically recorded using the
current date or time?

If there is such a field and the recording date is recorded then use (in
your query) the critiria under tha field =date().

If there is such a field and the recording date and the time is recorded then
using an empty column in your query type:

MyDate: CDate(Int([YourDateField])) and use the same criteria as mentioned
above.

GeorgeCY


Ο χÏήστης "Cardinal" έγγÏαψε:

I am using Access 2003. I am trying to create a query that returns
only records for todays date. I've tried now() and date()
unsuccessfully. Can someone give me hint on what to try? Thank you.

 

[Cardinal]

Thank you. It worked.