Help with an easy one

chastst

New Member
Joined
Dec 10, 2002
Messages
21
This will be easy for most of you, but I haven't messed with Access in quite some time.

I have a table with about 20 different fields. I would like to query on the Name field by allowing the user to select which name they would like to report on. Can someone help me with how to tell a query which condition such as Name that I want?

TIA
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
In the Criteria section of the Name field, enter...

[Enter a Name Please]

Anything in [] (brackets) in the Criteria field will prompt the user for input.
 

wsteinbe

Board Regular
Joined
Feb 16, 2006
Messages
58
You could also make a form (We'll call it FORM1) with a Combo Box (called COMBO1) on it. Have the combo box link to the name field on your table. Then make a button that opens your query. In your query under the field name criteria put: [forms]![FORM1]![COMBO1]

That way they can select the name instead of having to know it.
 

Forum statistics

Threads
1,136,266
Messages
5,674,728
Members
419,523
Latest member
Urnovio

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top