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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top