Query Today's Records

[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.

 

[Smartin]

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.

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.