All data for today

  • Thread starter Thread starter Dee
  • Start date Start date
D

Dee

In a call logging dbs. I need to query all calls logged
for the current date, not now but for the full day.
I know how to do between dates and monthly dates even
weekly, but cannot find the expression to query the full
days data.
 
You might try a query whose SQL looks something like this:

SELECT
[Your Table].*
FROM
[Your Table]
WHERE
[Your Table].[Your Date/Time Field] >= Date()
AND
[Your Table].[Your Date/Time Field] < Date() + 1
 
Dee

That would depend on what you've recorded. If your log row contains date &
time, you'll have to only "look" at the date portion to compare to what the
Date() function returns.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top