Display records one time only

  • Thread starter Thread starter FirstVette52
  • Start date Start date
F

FirstVette52

Primary Key is ID and data is extracted by ClubID. Fields are ID, ClubID,
StpMail, FNm, LNm, MI, AD1, CO, Cty, ST, ZP.

Prompt asks for up to 5 ClubID's, but the resulting Dataset has duplicates
(one ID may have been a member of all ClubID's)

ClubID is a year value (i.e., 2007). How do I restrain the data so I don't
end-up with Duplicate values?

Thanks in advance for any suggestions.
 
Almost Forgot: for each ClubID Criteria entered, 'StpMail' Is Null (to
eliminate invalid addresses).
 
Primary Key is ID and data is extracted by ClubID. Fields are ID, ClubID,
StpMail, FNm, LNm, MI, AD1, CO, Cty, ST, ZP.

Prompt asks for up to 5 ClubID's, but the resulting Dataset has duplicates
(one ID may have been a member of all ClubID's)

ClubID is a year value (i.e., 2007). How do I restrain the data so I don't
end-up with Duplicate values?

Thanks in advance for any suggestions.
Click to expand...

Open the query in design view, and view its Properties. Set the Unique Values
property to Yes.

Note that this answer is 'guessing in the dark' because we know nothing about
the query other than what you post; perhaps you could post the SQL view.
 
Try this --
SELECT YourTable.ID, YourTable.ClubID, YourTable.StpMail, YourTable.FNm,
YourTable.LNm, YourTable.MI, YourTable.AD1, YourTable.CO, YourTable.Cty,
YourTable.ST, YourTable.ZP
FROM YourTable
WHERE YourTable.ClubID = (SELECT Max([ClubID]) FROM YourTable AS [XX] WHERE
YourTable.ID = [XX].ID)
ORDER BY YourTable.ID;
 
Back
Top