Eliminating Duplicates for Report

[Guest]

Thanks in advance for your help. I am a newbie, so please be patient with
me. We are creating a report on a time reporting database that is organized
by project. What we are trying to do is a "master project list" by dates.
When we query the table, we bring in duplicate project names (because they
are listed by date), i.e. Project X on May 1st, May 15th, May 29th etc.
What we are trying to do is eliminate Project X showing up 3 times. When we
"hide duplicates" in the report, it leaves blanks all over where the
duplicates were. We need to condense down the report after hiding the
duplicates. How do we accomplish that?


Thanks in advance.

Brent

 

[Wayne-I-M]

Thanks in advance for your help. I am a newbie, so please be patient with
me. We are creating a report on a time reporting database that is organized
by project. What we are trying to do is a "master project list" by dates.
When we query the table, we bring in duplicate project names (because they
are listed by date), i.e. Project X on May 1st, May 15th, May 29th etc.
What we are trying to do is eliminate Project X showing up 3 times. When we
"hide duplicates" in the report, it leaves blanks all over where the
duplicates were. We need to condense down the report after hiding the
duplicates. How do we accomplish that?

Thanks in advance.

Brent

Hi

Try this

SELECT TableName.FieldName, Count(TableName.FieldName) AS
CountOfFieldName
FROM TableName
GROUP BY TableName.FieldName;

Or in design view

Create the query and include the project names field and the dates
field. Make this a totals query and (in the date field column) select
Group by Count. This will give you a sinlge occurance of each project
with a count of the dates. Base the report on the query and you will
have just one row for each project.

Hope this helps

Wayne
Manchester, England