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.

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.