0

Is it possible to get the max values from the columns in 1 table and copy them into another or would this not be recommended. The more I think about it the more I begin to think it isn't such a good idea.

Here's an example what I'm looking for:

TEST_TABLE
--------------------------------------
NAME     AGE     SCORE     LAPS
Devin     22      202       16
Brian     36      185        8
Heather   18      236       12

Is there a series of queries I can write to get me the max values found in each column? The rows are irrelevant as the max values will be used for formatting in a form.

I want the end table to look something like this:

MAX_TABLE
--------------------------------------
MAX_AGE     MAX_SCORE     MAX_LAPS
   36          236           16

Or would it be simpler to write some sort of query in the form for this? Is that even possible? I'm using Access 2007.

Edited by SacredFootball: n/a

1
Contributor
2
Replies
3
Views
7 Years
Discussion Span
Last Post by SacredFootball
0

Why doesn't this query work?

INSERT INTO MAX_TABLE (MAX_AGE, MAX_SCORE, MAX_LAPS)
SELECT MAX(AGE), MAX(SCORE), MAX(LAPS)
FROM TEST_TABLE;

I get a wonderfully helpful error stating:
"Reserved error (-3087); there is no message for this error."

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.