G
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.
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.