Total Newbie - getting around in Access

[Guest]

I have a simple table with 4 columns.
ColA = just sequential id numbers
ColB = machine ID
ColC = owner ID
ColD = date added to table

I want a report that will extract all the duplicates in ColB. This happens
when the machine moves from one owner to another (and possibly back again).

I have not worked in Access much (would really like to learn). I know I can
export to excel, do a conditional if and sort dulpicates, but it seems like
this could be done in Access. I have no clue - please be specific.

In the future, I would like to take this new report and pull addresses off a
different table and add to the report.

Thank you so much.

 

[Guest]

Use a find duplicates query and create a report using the results. To do
this just go to the queries and create a new query click on the New Query
Icon. In there you will see one marked "Find Duplicates Query Wizrd" and
just follow the steps. Once this is done and you have saved the query, click
on the arrow to the right of the new object icon and click on the report
icon. Then just follow those steps.

HTH


James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf