max in a row

[dz2k7]

I have a million line table in Access
12 columns have data of 12 months sales.
How to make a query that adds a column having maximum value of sales in each line.

 

[pbaldy]

That's not really good design, but here's a way:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209857

 

[dz2k7]

Excellent!
It works!
Thank you