Access 2003 eliminating duplicates

  • Thread starter Thread starter nalgal
  • Start date Start date
N

nalgal

I have created an action item database. An action item can be repeated in
the database since it may belong to different projects & are tracked by ecah
project. I am trying to generate a report for action items assigned to, but
in this report I only want to list an action item once per owner. I have
tried queries, filtering & different grouping in the report. What am I
missing?
 
Post the table structure, field names and datatype.
Post sample data.
Post what you would want the results to look like.
 
ID (primary) Autonumber
Project # Text
Action Item Text
Assigned To Number
Opened By Number
Opened Date Date/Time
Status Text
Category Text
Priority Text
Comment Memo
Due Date Date/Time

Sample Data

1
8-001
Mail project confirmation worksheet
Sam
Paul
1/1/08
open
sales
high
add cost of testing
12/31/08

For the report:
Assigned to: Sam

Project # 8-001 Mail project confirmation worksheet Opened By: Paul Due:
12/31/08

Comments: add cost of testing


In my report, Sam may have the same action item for several different
projects, but i only want it to be listed on the report for Sam once.


Thank you for the help!
 
In my report, Sam may have the same action item for several different
projects, but i only want it to be listed on the report for Sam once.
Action Items are at least the third level down in the report under Assigned
To and Project #.

If you do not list the action item for each project then how will you know
which project it is for?

Looking at your post it seems like there would only be one action item per
project or you only post a small part of your structure.
 
Thank you for responing. All I need is a list of action items to be
completed by the assignee. It is not important for the assignee to know the
project. The initial action item would have the first project number. The
other projects with the same action item could be closed out as well, by the
administrator in table view.
 
The only way I can think of is to use the Sorting and Grouping to group on
employee (employee information in header), group on action item (action items
in group header), and projects in details.
 
in your query that you are getting the duplicate records haev you
tryed using distinct in the sql view type select distinct insted of
just select it may resolve the duplication
 
Back
Top