find maximum value across fields in Access 2003

T

Tom Whyte

I have fields with monthly sales figures for two years for each customer
record and want to find the highest value sales in any month in a given year.
Using Access 2003. I am not skilled in Visual Basic and only able to use
Queries
 
A

Allen Browne

Tom, you would not normally set up a table like this in a database. Better
to have the sales values listed one per record than to have them in
different fields.

If you are stuck with the design, you could use the MaxOfList() function
from this link to find the highest value:
http://allenbrowne.com/func-09.html
 
Top