Max in a line

[dz2k7]

Hi everybody,

I know how to do that using VBA, but I want to figure out if there is a ready made function for that kind of calc.

Ok

Lets say I have historical monthly sales for the whole year in 12 columns for each product.

I need two things that I can easily do in Excel but not in Access.

1. I need to figure out the biggest monthly sale.
And
2. I need the second large monthly sale.

The problem is that regular Access Max function works by columns (vertically), but not by lines.

I have a feeling that Access have something similar to Excel for this, but I can't find it in Help.

Another case it could be used is when I want to get rid of something like that:

iif(A>B,iif(A>C,A,iif(B>C,B,C)))

and just use something like

MAX(A,B,C)

I just need a function like Max for the line not for the column.

Thanks

 

[pbaldy]

The design is probably flawed, but:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209857