how to find lowest of two numbers in access 2000 query

Thread starter Guest
Start date Aug 28, 2006

G

Guest

Aug 28, 2006

#1

how to find lowest of two numbers in access 2000 query

G

Guest

Aug 28, 2006

#2

You can do that by using IIf

IIf([Field1] < [Field2],[Field1],[Field2])

Share:

Facebook X Bluesky LinkedIn Reddit Pinterest Tumblr WhatsApp Email Link

Top