G Guest May 17, 2006 #1 I need a criteria formula to list all numbers from a table smaller that 1. Can any one help?
J Jeff Boyce May 17, 2006 #2 Open a new query. Add the table. Add the field that has the numbers. Add any other fields you wish to see. In the "Criteria" row under your "numbers" field, put: <1 Run the query. Regards Jeff Boyce Microsoft Office/Access MVP
Open a new query. Add the table. Add the field that has the numbers. Add any other fields you wish to see. In the "Criteria" row under your "numbers" field, put: <1 Run the query. Regards Jeff Boyce Microsoft Office/Access MVP
J John Spencer May 17, 2006 #3 ??? Field: yourNumberField Criteria: < 1 IF that is not what you want then you might want to post a more detailed description and perhaps a few values that you do want and some you don't want and identify which of those you would expect to see returned.
??? Field: yourNumberField Criteria: < 1 IF that is not what you want then you might want to post a more detailed description and perhaps a few values that you do want and some you don't want and identify which of those you would expect to see returned.
