Query to pull up members once once

  • Thread starter Thread starter Girlflexfan
  • Start date Start date
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.
 
Unclick the checkbox for the year and use Unique Records.

Cheers,
Jason Lepack
 
Omit the date as an output. If that does not fix then post your SQL.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I search for a specific year in a query? 2
linked fields in a query 3
Help Totaling More Than One Entry 2
Need query to sort by CurrentYear members 3
Profiling Members - please read. 9
Query troubles 4
Query Help 5
Members give more than once but need latest to send letter 1

Back
Top