how do i perform a Count(Distinct) query for 2 different column va

J

jay

how do i perform a Count(Distinct) query for 2 different column values using
GROUP BY

I have this "source" table like this....

|------------------------------------------|
|ROLLUP_ID | GAP_ID | REQ_ID | COST|
|------------------------------------------|
|001 | 001 | 002 | 12.00 |
|001 | 002 | 002 | 15.00 |
|005 | 005 | 009 | 9.00 |
|------------------------------------------|

I need a group by query with distinct for ms access 2007...

to make the following...aggregate query

|--------------------------------------------------------------|
|ROLLUP_ID | GAP_COUNT | REQ_COUNT | TOTAL_COST |
|--------------------------------------------------------------|
|001 | 2 | 1 |
27.00 |
|005 | 1 | 1 |
9.00 |
|--------------------------------------------------------------|

Any help would be so grateful...

I looked at this suggestion but I am not sure its applicable:

http://blogs.msdn.com/access/archive/2007/09/19/writing-a-count-distinct-query-in-access.aspx
 
D

Daryl S

Jay -

You may need to create separate queries for each count(distinct) you want,
and one to calculate the total cost, then combine the separate queries in a
final query using the ROLLUP_ID as the join field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help for building a statistical query, thanks a lot! 0
combining Count and GroupBy and Join? 4
how do i run a distinct count query in access? 1
access query to do the same as excel =IFSUMS 2
How do I count non-duplicated records in a query in Access? 1
How do I count the values in a column? 6
How do I get a distinct count of multiple records in a group? 1
How do I sum a column based on 2 different column headers/criteria? 0

Top