Thread: Max expression not working
04-09-15, 08:46 #1Registered User
- Join Date
- Mar 2015
Unanswered: Max expression not working
I'm having problems with the "Max" expressions. Basically i'm creating a sort of analytical query where a certain amount of information needs to be classed. In the screenshots i've taken you'll see my query and the Max expressions and then on the other hand you will see the results of that which aren't being classed from Max to least.
Does anyone have any idea what could be going wrong ?
Thank you all !
04-09-15, 10:47 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
I've never had the need to do this kind of thing, but it looks like the Min/Max fields you're dealing with are date fields, and they're not in the US date format. Access is very US-centric and using a different date format usually creates problems in Queries. Allen Browne (from 'down under') has an excellent article addressing how to work around this:
International Dates in Access
You're going to have to go directly into the SQL Statement behind your Query and modify that.
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007