Finding Max value of 2 fields in a Query

[Maturi]

Hi,

I have a query (qry_ListEmps) that produces the fields
- Name (text)
- ThisPay (number)
- LastPay (number)


I want a second query (qry_MaxPay) to generate the following:
- Name (as in qry_ListEmps above)
- MaxPay (number - that is the maximum of ThisPay and LastPay)

I need the qry_MaxPay as a Access Query rather than SQL in VB

Can you help please - Thank you

M

 

[Crowley16]

select IIF(field1 > field2, field1, field2) from table/query...

--------------------
Procrastinate Now!