Table stores date as Now(). Need to run query to sum on date().

[hefly]

My table stores the date in the Now() format. I need to run an aggregate query to count the number of times the record is stored by date, i.e. the number of times a record is intered on any given day.

How do I convert?

Thanks

Hefly

 

[hefly]

I figured this out!! Simply change the field properties in the query!

Thanks.

Hefly