Peter Bellamy
Registered User.
- Local time
- Today, 03:18
- Joined
- Dec 3, 2005
- Messages
- 295
I can't get my head around this, can someone help.
I have a selection of Price lists for different customers each has their version of a price list for several different products. The products don't change, just the customer and the price they get.
I have created individual queries and reports for each of the variants. They vary just by the two variables, customer and product.
A long list but it has been done over time.
Now any change requires editing nearly every query and nearly every report, too time consuming !
What I want to do is code it in VBA using SQL statements to provide the query for the reports, altering the variables in the query, in it in a loop, to get the different product price lists.
That way it should be possible to boil it down to a short bit of code but I am stuck on how to pass the output of the queries to the reports?
Cheers
pnb
I have a selection of Price lists for different customers each has their version of a price list for several different products. The products don't change, just the customer and the price they get.
I have created individual queries and reports for each of the variants. They vary just by the two variables, customer and product.
A long list but it has been done over time.
Now any change requires editing nearly every query and nearly every report, too time consuming !
What I want to do is code it in VBA using SQL statements to provide the query for the reports, altering the variables in the query, in it in a loop, to get the different product price lists.
That way it should be possible to boil it down to a short bit of code but I am stuck on how to pass the output of the queries to the reports?
Cheers
pnb