antieuclid (antieuclid) wrote in ms_access,
antieuclid
antieuclid
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

    Error

    default userpic
  • 1 comment