Query not returning proper results for just today?

  • Thread starter Thread starter Bayou BoB
  • Start date Start date
B

Bayou BoB

Simple question this time I'm sure. I have a query I'm building to
return all of the appointments for a single day. The query works with
nothing in the criterion box, returning all of the appointments
entered. However, when I put Date() in the criterion box to just get
today's appointments, it returns no records even though there are
appointments for today. I'm wondering if this has anything to do with
the fact that i have both date and time in the ActDate field. Do I
need to put in something like Date() AND Time()...? What would the
proper entry be for the criteria box? Many thanks.

Kevin
 
Kevin,

Yes, it is because you have time data in the field as well as date.
Make a calculated field in a new column in your query design grid,
like this...
AppointmentDate: Int([ActDate])
.... and then apply your Date() criteria to this column.

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble with date and time in same field in a query...! 1
Access 2007 - Add simple Line number to queried records 5
Return records entered today 14
Min/Max Dates and Group By 2
Checking dates via a select query? 2
limiting query results 4
Combine Duplicates in Query 0
Query Criteria using a Time Field 2

Back
Top