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
 
Back
Top