Keep getting duplicates.. HELP!!

N

Nadia

Here's the background:

I have a table named "Inspections Data" and within the
table are the following fields: ID(unique #), Unit Number
(number that appears on the unit being inspected),
Employee ID (the inspectors assigned id #), Date (date of
inspection), and Code (inspection code). There may be
multiple codes entered for an id, in this case there are
two or more records with the same Id number and different
codes descripting the inspection results.

Within the table are regular inspection data and auditing
data. The auditing data will match with inspection data
by the unit number. (Auditors re-inspect units that were
already inspected to verify completeness.) The way to
tell if data is from an audit or an inspection is by the
Employee Id. Auditor is i.e. XX1234 and the id of an
inspector is i.e. 12345 (auditor's id always begins with
XX)

I'm attempting to prepare a query or queries that will be
used in a developing a report. I want the report to
layout unit that were audited per inspector. So I'd like
the unit number displayed then the inspector's id
followed by the date and corresponding codes then the
auditor's id followed by the date and corresponding codes.

PLEASE HELP...i have one together but keep getting
duplicate records. ANY SUGGESTIONS ARE MUCH
APPRECIATED!!!

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top