find maximum value across fields in Access 2003

[Guest]

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

 

[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

 

[Joseph Meehan]

As Allen said, that is a poorly designed database. Databases like
different designs than spreadsheets. Those monthly figures should be in a
separate related table. Users need not know that as you can make a form
look like the table does now.

Doing it right will allow more than just this function to work. Not
changing it is likely to come back at you over and over making far more work
for you than just changing it now. It is called "Normalizing" the data.
Access even has a wizard to help you out.