Max of more fields

[ppataki]

Dear All,

I would like to calculate the max of the sum of certain fields in one of my tables
So eg. I have 4 fields, Sales1....4
If I do Sales1+Sales2 then Sales2+Sales3 then Sales3+Sales4 I need to know which one of these sums is the highest
(with a query, or with VBA if possible)

Could you please advise?
Many thanks in advance

 

[ajetrumpet]

this is complicated to do, and the reason is because this is not a normalized data setup.

your sales records should be just that, RECORDS. not fields in a table. i would seriously suggest fixing this before you go further, but that's just an opinion

 

[ppataki]

OK, how should I fix that? (btw these are records, I just need to do that calculation with them somehow)
Thank you