Duplicates in One Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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