Mailing List Append Query

[harryfraser]

Hi,

Been a while since I posted on here but altering the previous project I worked on...

I am trying to create a mailing list feature for the database I previously worked on. I am doing this using an update query. My table structure is as follows:

Contacts
Title
FirstName
Surname
Institution (FK)
Address 1
Address 2
Address 3
Address 4
Address 5
Town/City
Postcode
E-mail
Mailing-list

I want to use an append query to add all the above fields into another table called mailing list (which has all the same fields as above). However, I only want this to be done for the selected record in the contact form. the user will then click a macro button that says 'add user to mailing list'.

Can someone explain to me how I can do this?

Thanks

Harry

 

[jzwp22]

You would not have another table that duplicates the information that is already in another table; it is not a good database practice. The easiest being just having a yes/no field in the table. In your form, if you want someone to be on the mailing list just click the yes/no to yes.

You can then use a query to find all of the people who are on the mailing list by using the criteria section of the query to reference the yes/no field. A checked yes/no field has a value of -1, unchecked it would be zero.

SELECT *
FROM tablename
WHERE yesnofieldname=-1