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
 
Back
Top