Avoid multiple queries 2

[TrekBiker]

I have ended up with 12 queries derived from the same one, just changing the criterion value on one field each time. The queries are launched from a set of individual buttons on the form. How can I simplify this? The objective is to keep the number of queries down because there are already too many of them. I don't want to use a query that looks up the criteria in a separate form. The only places the names appear are in labels on the form beside related data for each criterion.

 

[Andrzejek]

Where are you getting the value of "Bottled Beer" from other than hard-coded? Is there a combo box the user can select the CaskGroup?

I'm picking up the CaskGroup for each type from a set of label captions for fields with related total calculations

So I would guess all of that is hard-coded.

One would assume you could get this data into a combo box from a request like this:
[tt]
Select Distinct CaskGroup
From qrySalesDetailsNet
Order by 1[/tt]


---- Andy

There is a great need for a sarcasm font.