Results 1 to 3 of 3
  1. #1
    vijanand1279 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2011
    Posts
    2

    Query to extract maximum figures for each date

    Hi,

    I need help to extract rows with the highest production figures for each entry dates.

    I have attached the files for your reference. I tried something but it does not work.

    Regards,
    Vijay
    Last edited by vijanand1279; 11-03-2011 at 10:42 PM.

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Look at what I did in Query1 and then I used that in Query2. I think this is what you asked for.

  3. #3
    vijanand1279 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2011
    Posts
    2
    Hi Bob,

    This is what I was looking for. I could understand that you have used Query 1 to get our desired data on Query 2. Thank you so much.

    REgards,
    Vijay

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Displaying weekly figures?
    By djclntn in forum Queries
    Replies: 8
    Last Post: 10-11-2011, 08:03 AM
  2. Extract Creation/Last Edit Date
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 02-15-2011, 07:12 AM
  3. Replies: 2
    Last Post: 06-22-2010, 07:09 AM
  4. Replies: 4
    Last Post: 03-31-2010, 03:41 PM
  5. Query to extract record of particular year
    By pkg206 in forum Access
    Replies: 2
    Last Post: 11-11-2009, 10:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums