multiple criterea selection to get data from an excel chart?

L

LeAnn Cassiday

what we are wanting is a data base that will let you pick 4 varibles then it
will go to the excel speadsheet and based on the criterea pick the one part
number they need I am not sure how to set this up.
 
K

KARL DEWEY

Link the Excel - menu FILE - Get External Data - Link tables. Select Excel
file type and find the file - follow prompts.
Build a query by pulling down all the fields (Excel columns). Build a form
using the query as record source. Make the fields for four variables you
want to pick as ListBox. Add a Command button. Create an event or write a
macro to run the query.
In the criteria for the query use the following --
Like [Forms]![YourForm]![ListBox1] & "*"
If no selection is made for some or all of the ListBox and the Command
button is pressed the query will pull records based on what is selected and
ignore the ListBox not picked.
 
Top