Parameters for Query

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

Sujith

You can do this easily using a parameter query in Excel. I have an
explanation here, works with multiple parameters.

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Sujith" <[email protected]> wrote in message
news:[email protected]...
>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
>
>