Query to pull up members once once

[Girlflexfan]

I have an access db with 2 tables, one with members and their mailing
information (contact_infoTBL) and another with their order information
(member_yearTBL) Since they can order membership by year, that table
only consists of 2007, 2006, etc. along with payment information.

I want to pull up only those members from 2007 or 2006, but show their
mailing information only once.

My query is searching member_yearTBL under the year for 2007 or 2006
and also includes all the mailing details (addrss1, city, st, zip,
etc).

I set the properties to UniqueValue=yes and subsequently
UniqueRecords=yes but both of these ran the same results which
included, for example, a member who paid for 2007 and 2006 shows up
twice.

Please help! I am extreme novice at this.

 

[Jason Lepack]

Unclick the checkbox for the year and use Unique Records.

Cheers,
Jason Lepack

 

[Guest]

Omit the date as an output. If that does not fix then post your SQL.