newbie help No2

  • Thread starter Thread starter potbelly
  • Start date Start date
P

potbelly

Guest
I had no replies from the first post,so i will explain a little more my objective and hopefully someone will take pity on me and point me in the right direction.
I am trying to sort out my folders of membership e-mails. this is not for spam or anything like that it is my autism site. http://www.paains.org.uk
Up to now my database for members has been various folders in my address book. classy hey.
I have a main table with the mails that i definatly sent out last week.
Now i have 10 tables with the addresses gathered from various folders on my address book.
All of this is now in the same db.
All i want to do is strip tables 1-10 of all the addresses that duplicate in the main table. This will leave me with a list of adresses that i didn`t send last week.
I can then send them, add them to the master table and from now on use access to store all my data from future forms.
The forms bit is next months project.
Please help me someone. point me in the right direction.

gratefully
Potbelly
 
PotBelly,

seeing as it's a good cause, if you are using Access97 you are welcome to send the entire database to me and I'll sort it out for you.

e-mail me if you want, otherwise I can go through it online if you wish.

Ian
 
I feel that i am getting close to what i want to do.
Each of my tables has just one field. I am happy to go through each table one at a time at this stage so this is what is happening.
Using query wizard i select field1 from the master and field1 from table1

Master1 is the addresses i mailed last week.(150)
table 1 is the addresses i mailed in december (132)


I click close and a table opens with the two fields side by side showing the matching addresses. (112)

So there are 20 addresses that i didnt send last week in table1

However the query is only showing me the ones i did send.

How do i delete the results of the query from table1 thus leaving table1 holding the 20 fresh addresses.

Thank you all for your time
 

Users who are viewing this thread

Back
Top Bottom