Hi,
How to write a query to get minimum number by comparing with other fields?
I have example in excel as shown below
Filds:Q R1,Q R2,Q R3,Q R4,Q R5 and Running Price
Running Price==MIN(AO4:AS4) Means Comparing Q R1,Q R2,Q R3,Q R4,Q R5 and getting minimum value from that fields.
Can anyone suggest me,How to do it in access?