Karl:
Those should be HAVING clauses, not WHERE clauses. The former operates after
grouping, which is what's wanted here, the latter before grouping.
Ken Sheridan
Stafford, England
KARL DEWEY wrote:
All I can think of is to check that [Breed Description Table].Breed and
[Exhibitor Table].[Exhibitor ID] are unique in these tables.
An easy way is to run a query like this --
SELECT [Breed Description Table].Breed, Count([Breed]) AS CountOfBreed
FROM [Breed Description Table]
GROUP BY Breed
WHERE Count([Breed]) 1;
and
SELECT [Exhibitor Table].[Exhibitor ID], Count([Exhibitor ID]) AS
CountOfExhibitorID
FROM [Exhibitor Table]
GROUP BY [Exhibitor ID]
WHERE Count([Exhibitor ID]) 1;
Ahh gotcha. Ok so what do you need to know next?
SELECT [Breeding Cattle Table].[Entry No], IIf([Breeding Cattle
[quoted text clipped - 37 lines]
can find no correlation as to why it could be choosing these as duplicates.
Any direction?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201002/1