Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Microsoft Access 2007 Query Help

26 Dec 2010   #1

Windows 8.1 Pro x64
 
 
Microsoft Access 2007 Query Help

Hi,

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.

Name:  Capture.JPG
Views: 7
Size:  26.6 KB

Regards,
JDobbsy1987



My System SpecsSystem Spec
.

Reply

 Microsoft Access 2007 Query Help




Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:57 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33