Hello, I have a table with 3 fields - Name, Lap1, Lap2. I want to create a query that will shows the result with 2 fields. The 2 fields are Name and Best_Lap. The Best_Lap is the minimum between Lap1 and Lap2. How can I do this? I know I can use
iif(). But if I have more fields (Lap1,...Lap10), it might be too complex to use IIf. I am thinking about using Min function but it ...