Max of 3 fields (with numbers) in the same table

[insea]

Hi people,

I have 3 fields in one table and i would like to have at the some time the max of this fields. Can you help me?
Regards

insea

[asingh]

Hi,

Attached is a data base....though there are 2 scenarios.

1. You have one field with the max value. (table1)
qry_gt_max_num : will get the max number from the table. (Group by query)
qry_dsp_max_field : will display the field with max number. (Inner join/select query)

2. You have two fields with the max value. (table2)
qry_gt_max_num2 : will get the max number from the table. (Group by query)
qry_dsp_max_field2 : will display the fields with max number. (Inner join/select query). Here two fields have the max number.

hope it helps....

regards,

asingh

[insea]

I asingh,
it's work perfectly.
Thanks a lot and congratulations for this site.

Regards.
Insea