Results 1 to 2 of 2
  1. 11-24-2011, 09:48 AM #1
    audrey
    audrey is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    1

    MAX in Access

    Hello,

    I have two fields in my query first is month

    Field 1
    201010
    201109
    201007
    etc...

    Field 2
    XYZ
    ABC
    DEF
    XYZ
    etc...



    I want to make a query that will count only once Field 2 values and match the MAX value in field 1.....


    is that possible ??
    Reply With Quote Reply With Quote
  2. 11-24-2011, 10:09 AM #2
    alansidman's Avatar
    alansidman
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    See my response here

    http://www.mrexcel.com/forum/forumdisplay.php?f=18

    Crosspost

    http://www.excelguru.ca/content.php?184
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums