OK I am sorry but that still does not work, change of plan.... can you tell me how to Query to find records that are NOT EQUAL to the Max Date?
For some reason, that DMAX function is not behaving as it should. So, I took a little different approach, using a Subquery (which really just returns the Max Date which we are using as Criteria).
Open a new query, change to SQL View, and paste this code in there and then change to Datasheet View to view the results.
Code:
SELECT DISTINCT[Business Unit],[Full Name],[Opportunity Number], [Name], [Sales Stage 2], [Report Date]
FROM [MK TBL MGMT Report Shell with Dates]
WHERE [Report Date] Not In
(SELECT Max([Report Date])
FROM [MK TBL MGMT Report Shell with Dates]);
Does this give you what you are looking for?