Duplicates in One Field

I have searched and read all the documents on Duplicates but they are not
full helping me with my question.

I have a query that has 3 fields, Name, Number, Date
Then I want to count the unduplicated Numbers in a cross tab query by month
and for each name.
Is this possible, I keep getting the duplicate Number fields when I add
Date to the query.

Post the SQL for your crosstab query, sample date for it, and what you want
the results to look like.

"SBow" wrote:

I have searched and read all the documents on Duplicates but they are not
full helping me with my question.

I have a query that has 3 fields, Name, Number, Date
Then I want to count the unduplicated Numbers in a cross tab query by month
and for each name.
Is this possible, I keep getting the duplicate Number fields when I add
Date to the query.

Use a Base Query to get distinct value set
SELECT Distinct T.Name, T.Number, Format(T.Date,"yyyy-mm") as YrMonth
FROM YourTable as T
WHERE T.Date Between #1/1/2005# and #12/31/2005#

Use that query as the source for your crosstab.

"SBow" wrote in message
news
I have searched and read all the documents on Duplicates but they are not
full helping me with my question.

I have a query that has 3 fields, Name, Number, Date
Then I want to count the unduplicated Numbers in a cross tab query by
month
and for each name.
Is this possible, I keep getting the duplicate Number fields when I add
Date to the query.