ACCESS FEED: RE: [MS_AccessPros] How do I prevent duplication of records?

Rabu, 27 Maret 2013

RE: [MS_AccessPros] How do I prevent duplication of records?

At 28/03/2013 08:03 AM, you wrote:
>Which are the three fields that shouldn't allow duplicates?

> > > > > I have a table which includes the fields: "MemberID" and
"YearID" and
> > > >"PostID

>Which field is the primary key field in the table?

"tblDistOfficeID"

>I would have expected a simple totals query like:
>
>SELECT MemberID, YearID, [Other Field], Count(*) As NumOfRecords
>FROM tDistrictPostHolders
>GROUP BY MemberID, YearID, [Other Field]
>HAVING Count(*) >1;

The SQL was generated by the Wizard.

I have revised your SQL to:

SELECT tDistrictPostHolders.MemberID, tDistrictPostHolders.YearID,
tDistrictPostHolders.DistPostID, Count(*) AS NumOfRecords
FROM tDistrictPostHolders
GROUP BY tDistrictPostHolders.MemberID, tDistrictPostHolders.YearID,
tDistrictPostHolders.DistPostID
HAVING (((Count(*))>1));

Which also returns no records.

Cheers,

Robin