can I create a function to display the lower of two fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a query I would like a field that would show the lower of two fields,
similar to the MINA function in Excel
 
iif([fielda]<[fieldb],[fielda],[fieldb])
you might have to be careful with null, though. Are these required fields?

-John
 
You must log in or register to reply here.

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

Update Query Help *urgent* 0
upper and lower limit function. "BETWEEN.....AND....." 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Multi-word string from one field to two fields 2
Count text values in a Access Field 0
Help with a "like" query between two fields from two different tables... 2
Selecting between two values in a query 6
How to query a text string when case is in upper and lower 3

Back
Top