PLZ HELP !!!!!!!!!!!

M

Mita

Hi

Am trying to create the max expression in Access. Need the Max
expression for 3 columns , row-wise in a single table

Column1 Column 2 Column3
200 300 100

max in excel would be Max(Column1, Column2, Column3), however when i
try this in access, it simply does not calculate.

Plz help

Mita
 
D

Douglas J Steele

IIf(Column1 > Column2, IIf(Column1 > Column3, Column1, Column3), IIf(Column2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Table and Subtable in RDLC 5
Expression Column Or SQL Query 2
Report, Shrink, hiding blank lines 3
Excel Macro to Compare two Columns and write to a third 1
ODBC and Excel 1
C# WinForm DataGridView question 2
Combine multiple columns into two long columns, Repeating rows in first column 2
SQL to query columns that are in seconds since 1/1/1970 6

Top