Is there a way in Access to get a maximum value from many columns.

D

Duane Hookom

Please feel free to reply with a question in the body of the message. Also
provide example data and desired results.

You might want to provide some justification for calculating across columns
rather than across rows. Any calculations across columns suggests an
unnormalized table structure.
 
A

awall98

I have 52 weeks of sales per item number. As they come out of our master
files each week is in a separate column. I need to find the maximum amount
of sales out of these 52 fields.
 
D

Dale Fye

Have you considered using Excel? It works great on these spreadsheet style
operations!

I do have a function which will accept multiple values as a parameter array,
and identify the maximum value from among those values. If you would like me
to send you the function, let me know.
 
Top