View Full Version : Data Type Mismatch for Criteria in a Date field


aproctorpe001
11-28-2001, 02:01 AM
I have a query where I'm tried to find the most recent meeting date between an employee and a client. I've tried using the Max function in the Criteria field but I'm getting 'Data Type Mismatch Error' and I'm unsure why?

Rich
11-28-2001, 04:48 AM
Press the sigma button when in design mode to change query to totals, GroupBy Client etc Max Meeting date.