In this case, I want to make a query that only shows id "13" and "15", where "number1" is less than "number2".
In this case, I want to make a query that only shows id "13" and "15", where "number1" is less than "number2".
This is quite a strange first request - but here you go;
SELECT ID
FROM YourTable
Where Number1 < Number2
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
thank you!