how to find lowest of two numbers in access 2000

[Guest]

how to find out lowest of two numbers in access 2000 query

 

[Duane Hookom]

You didn't give us much to go on. Assuming you have a field [Num] in
[tblNums]:

SELECT Min(Num) as MinNum
FROM tblNums;