If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Criteria All Records
Access 2003
I am using a query to return a group of products. in the criteria box I have this [Please enter product number] Obvisouly when the query is run the user is prompted to input the product number. This works great. What should the user input to return all products or what is the code to write for the criteria. Thanks Bob Raley |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
querie Criteria date range and find records on ProductType | Rodrigo R via AccessMonster.com | Running & Setting Up Queries | 1 | August 5th, 2005 11:26 PM |
REQ: Need Criteria expression that will ask for "from" and "to" dates and then select records that fall within that date span for access 2000 Please...TIA | Ralph Malph | General Discussion | 8 | April 19th, 2005 07:36 AM |
REQ: Need Criteria expression that will ask for "from" and "to" dates and then select records that fall within that date span for access 2000 Please...TIA | Ralph Malph | Running & Setting Up Queries | 2 | April 18th, 2005 05:21 AM |
In Access, How can I set criteria to only choose records NOT cont. | schwdm | Running & Setting Up Queries | 1 | January 27th, 2005 05:15 PM |
Complex query criteria - desperate appeal | Ted Allen | Running & Setting Up Queries | 5 | November 17th, 2004 06:14 PM |