Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-07 : 07:41:30
|
| gamadon writes "Hi experts!I'm working on an MSaccess database (an XP edition) which contains details of sales.I'd like to print 2 reports (based on queries):1. Percentage of sales of specific products. (So. I'm supposed to sum ALL sold products and take the number of units sold from a specific product, and then devide: no_of_units_of_product/sum_of_all_sold_products.)2. Distribution of sales of products for each month. (So, I'm supposed to take the number of sales for each product, AND then print it so that I'll get a list ordered by months, and for each month - number of sales for each product.)Well, I tried lots of ways to combine several queries, but I'm not sure the access liked it at all...Could you help me?Please???" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-08-08 : 10:32:56
|
| How many tables?Also you do know that Access has a lot of reporting features for things like grand totals, ect...Brett8-)SELECT POST=NewId() |
 |
|
|
|
|
|
multiple queries