R
Rebeca
Please help me find a solution so I don't have to manually go through 14,000
lines![Smile :) :)](/styles/default/custom/smilies/smile.gif)
I imported an excel spreadsheet into Access to find the duplicated records.
I created a duplicate query where I have identified all of the duplicates in
a table. What I now need to do is identify the rows that do not have the same
"rendering"
For example, Encounter 1 is duplicated with rendering of M.Jones and
C.Jones. I need to see those encounters. Those that have the same rendering,
I could care less.
Here is my SQL.
SELECT CVI.Encounter, CVI.Rendering
FROM CVI
WHERE (((CVI.Encounter) In (SELECT [Encounter] FROM [CVI] As Tmp GROUP BY
[Encounter] HAVING Count(*)>1 )))
ORDER BY CVI.Encounter;
Thank you in advance![Smile :) :)](/styles/default/custom/smilies/smile.gif)
lines
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
I imported an excel spreadsheet into Access to find the duplicated records.
I created a duplicate query where I have identified all of the duplicates in
a table. What I now need to do is identify the rows that do not have the same
"rendering"
For example, Encounter 1 is duplicated with rendering of M.Jones and
C.Jones. I need to see those encounters. Those that have the same rendering,
I could care less.
Here is my SQL.
SELECT CVI.Encounter, CVI.Rendering
FROM CVI
WHERE (((CVI.Encounter) In (SELECT [Encounter] FROM [CVI] As Tmp GROUP BY
[Encounter] HAVING Count(*)>1 )))
ORDER BY CVI.Encounter;
Thank you in advance
![Smile :) :)](/styles/default/custom/smilies/smile.gif)