Calculated field, finding minimum of 2 values

H

Hunter

I have a calculated field where I need to compare a
constant to a value calculated based on other fields in
the query and determine the smaller of the two values. I
have tried the Min and Mina functions but they do not
appear to work in calculated fields. Please help.

Hunter
 

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

Split form 0
Calculate the median value before a specified list 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Earned value (BCWP) showing as zero in chart 0
Overflow error on calculate field in query - Help Please 1
Goal Seeking via Excel 0
Parametery Query 3

Top