Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015
    Posts
    31

    Unanswered: Max expression not working

    Click image for larger version. 

Name:	1st case.PNG 
Views:	5 
Size:	48.1 KB 
ID:	16291Click image for larger version. 

Name:	Result.PNG 
Views:	5 
Size:	44.6 KB 
ID:	16292

    Hello everyone,

    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 !

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •