If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query reporting problem
Hi, i have a company table like :
Company Product Sales Resp. category etc..... cmp1 prd1 SP1 ctg1 cmp1 prd2 SP1 ctg1 cmp1 prd3 SP1 ctg2 cmp1 prd4 SP2 ctg1 and so on.... i have a reason not to seperate products from the company table, because i want to enter all the information to a product like a company (i mean to use all company fields) i want to have a report with a result like: Sales rsp. NAME (SP1 for example) "Number of companies" "Number of products" ctg1 1 2 ctg2 1 1 i can write a query for showing "Number of companies" and "Number of Products" seperately, but not in the same report Any help would be muchly appreciated. |
#2
|
|||
|
|||
Query reporting problem
Based on this:
"i have a reason not to seperate products from the company table, because i want to enter all the information to a product like a company (i mean to use all company fields)" ....all you got is a messy spreadsheet. If you normalize your data, you will achieve your goal much easier. -- Steve Clark, Access MVP FMS, Inc. Professional Solutions Group http://www.fmsinc.com/consulting/ "Andy" wrote in message ... Hi, i have a company table like : Company Product Sales Resp. category etc..... cmp1 prd1 SP1 ctg1 cmp1 prd2 SP1 ctg1 cmp1 prd3 SP1 ctg2 cmp1 prd4 SP2 ctg1 and so on.... i have a reason not to seperate products from the company table, because i want to enter all the information to a product like a company (i mean to use all company fields) i want to have a report with a result like: Sales rsp. NAME (SP1 for example) "Number of companies" "Number of products" ctg1 1 2 ctg2 1 1 i can write a query for showing "Number of companies" and "Number of Products" seperately, but not in the same report Any help would be muchly appreciated. |
Thread Tools | |
Display Modes | |
|
|