Data Type Mismatch for Criteria in a Date field

aproctorpe001

Registered User.
Local time
Today, 04:30
Joined
Nov 19, 2001
Messages
17
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?
 
Press the sigma button when in design mode to change query to totals, GroupBy Client etc Max Meeting date.
 

Users who are viewing this thread

Back
Top Bottom