Query Today's Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

How do query records that are data from today? I have a field called
"ToDate" and I want to run a query that asks for all activity today and
calculating the total dollars coming in from a field called "Amount".

I think I put Date() in the CRITERIA entry area, is that right?

Please help, thanks.
 
The said:
Hello,

How do query records that are data from today? I have a field called
"ToDate" and I want to run a query that asks for all activity today and
calculating the total dollars coming in from a field called "Amount".

I think I put Date() in the CRITERIA entry area, is that right?

Please help, thanks.
Click to expand...

You are on the right path... Did you try it? Your idea will work if the
"ToDate" field is a whole number (date not including time). If the field
contains time, you will need to modify the Field expression to look
something like this:

(Field:) MyDate: Int([ToDate])

To total Amount, create a totals query, group by MyDate and sum the Amount.
 
Back
Top