Query reporting problem

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

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.
 
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.
 
Back
Top