antieuclid (antieuclid) wrote in ms_access,

Eliminating duplicates in queries?

I'm working with a membership database that includes two linked tables, one of the members and one of the memberships that they've purchased. I'd like to make a query that lists all the members for whom there is membership purchased. But some people like to submit multiple memberships, and I only want them to show up on the list once. What's the best way to do this?
  • Post a new comment


    default userpic
  • 1 comment