Results 1 to 2 of 2
  1. #1
    hawkins is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    82

    Query to select minimum value across different fields in a record

    I am wondering how to create a query that selects the minimum value across 3 different fields in the same record and places that min. value in the field of MinValue. I am used to using the design view in a query instead of writing the SQL code so I am unfamiliar with writing the code.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 3
    Last Post: 02-28-2012, 12:12 AM
  2. Replies: 1
    Last Post: 08-30-2011, 07:35 AM
  3. Criteria for a minimum itself
    By hawkins in forum Access
    Replies: 17
    Last Post: 07-27-2011, 12:57 PM
  4. Querying the "minimum value" record
    By LunaticFringe82 in forum Queries
    Replies: 1
    Last Post: 06-02-2011, 04:10 PM
  5. Replies: 1
    Last Post: 09-22-2010, 08:03 AM

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