Finding MAX value among record data

[srburk]

Lets say I have 10 fields in a record. Each are unique in that they are all numbers (or time fields).

Is it possible to run a query to determine the highest value amongst the ten fields in the record.

For example, if one record contains the following values in 10 different fields:
12
65
72
25
13
21
22
33
10
01

...could a query field be added to say the max value amongst the ten fields in this record is 72?

 

[ssmithri]

Scott,

Yes... create a select query, and then click on the summary button (looks like a Greek E) on the toolbar. Drag the field you want down from the table, then in the "Total:" row, click and select "Max"

This should do it.

Stu

 

[neileg]

Scott,

Yes... create a select query, and then click on the summary button (looks like a Greek E) on the toolbar. Drag the field you want down from the table, then in the "Total:" row, click and select "Max"

This should do it.

Stu

No Stu, ten different fields.

Looks like your database isn't normalised. You should be using ten rows in a subtable not a repeating group in the main table.

 

[ssmithri]

Thanks Neil... I overlooked different when I saw a column of data.

I agree, the data needs to be normalized first.

Stu