Parameters for Query

  • Thread starter Thread starter Sujith
  • Start date Start date
S

Sujith

I have an query from Access database which depends on 3 parameters (user
selects from dropdown box). I need the parameters to be dependent on the
others i.e. When I select Team A if should list All TeamA records and when
2nd parameter BrandA is input it should show records dependent on those two
criteria and hence forth. Is this possible? Any help would be appreciated.

Team Brand Area Sales Vallue
A BrandA Area1 100
B BrandA Area1 105
C BrandB Area1 150
A BrandB Area2 110
B BrandC Area2 100

thanks,
SS
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Select Query Prompting for NonExistent Parameter 8
Parameters error in Cross Tab Query 0
Parameter Query: Limit Parameter 7
Access 2003 Forms and Subforms with Parameter Query 9
parameter query not prompting for parameter 3
how to pass a parameter to a query base of a query that is the base of a report 0
Count records in Parameter Query for Report 3
Passing a query parameter using code to feed a subform 4

Back
Top