Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    1

    Unanswered: Need help with a query

    I am hoping someone can help with a wall I have run into. I have a database with a series of numbers in respective fields in the database

    (e.g. field1=300, field2=200, field3=100, etc...) can anyone tell me how I set up a query so the I get the max min and avg of each record instead of each field?

    Thanks in advance for your help

  2. #2
    Join Date
    Mar 2002
    Location
    Sacramento, CA
    Posts
    7
    No way to do this in a query that I am aware of.

    You might try posting in on the news server:
    thedbcommunity.com news server

  3. #3
    Join Date
    Feb 2002
    Location
    NYC
    Posts
    16
    You would have to do that using a script.
    -DL

  4. #4
    Join Date
    Feb 2002
    Location
    NYC
    Posts
    16

    query

    Actually, you could do that with a compound "set" query -- but I never really figured out how to work those. You could also do it using a series of 3 or 4 queries in a row. It would be a little pain in the neck to set up, but once you did, you could save it and re-use it as needed.

    -DL

Posting Permissions

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