|26 Dec 2010||#1|
| || |
Microsoft Access 2007 Query Help
I could do with help with a query..
I have managed to create queries that prompt for 'Contain' and 'Greater/Less Than'
I am now wanting to create a query that prompts for a specific category.
I know i can do this by putting [Enter Category] in the criteria but if the user spells something wrong it will not show so i wanted a list instead...
e.g. when the user runs the query it will say "Please Select a Category" and then it will display the list of categories.
I already have a table with all the categories but not sure how to get the query to reference it and display it in a list.
|My System Specs|
|Similar help and support threads for2: Microsoft Access 2007 Query Help|
|MS Office Project 2007 Pro Activation query||Microsoft Office|
|Access 2010 query parameters||Microsoft Office|
|Microsoft Office 2007 Access Queries||Microsoft Office|
|Running an executable file from inside of Microsoft Access 2007||Microsoft Office|
|Any problems using Access 2007 database with Access 2010?||Microsoft Office|
|Cannot access the Ribbon functions in Excel 2007 or Word 2007||Microsoft Office|
|Cannot Scroll in Microsoft Access 2007||Microsoft Office|