Date Format Column Causing "Data Mismatch" Error

[shelby55]

Hi

I'm using Access 2010. I have a table of data and I want to group on discharge month. I require the month to be a month for sorting reasons later.

The formula is: MonthEnd: DateSerial(Year([DisDate]),Month([DisDate]),1)

This works great but when I try to group my query, this columns is producing the error of "data type mismatch in criteria expression". This works in Access 2003 so why wouldn't it work in 2010?

Thanks.

 

[PHV]

What is the SQL code of your query, and which criteria expression raises the error ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

Is the DisDate field ever null? If so, I would expect errors.

Duane
Hook'D on Access
MS Access MVP