Date Format in Crosstab Query

[John Baker]

I am trying to create a crosstab query that counts the number of events that have been logged for each day of the month. The event date is stored in an ODBC compliant database in date/time format. Unfortunately, the crosstab query counts the number of events for each date/time occurrence.

I have tried entering the following expression in the Field: definition with no success (no records are returned when the query finishes executing):

Expr1:Format([OPEN_TIME]),"mm/dd/yyyy")

I am stumped! Any help would be appreciated.

Thanks,
John

 

[John Baker]

Pat,

Thanks for your response. Unfortunately, I continue to have a problem with this query. Here is what I have defined for the Date field:

Field:Expr1ateValue([OPEN_TIME])
Total:Group By
Criteria:Between #5/1/2006# And #5/31/2006#

When the query runs, it returns the error, "Data type mismatch in criteria expression".

??
John