Parameter queries

Hello Ta,

Hope you enjoyed your Microsoft Access courses with BEST Training.
Thank you for your question regarding moving data from one table to another.

Depending on your table layout, you may have several options:

1. Direct Copy
If your tables are EXACTLY the same structure as each other, you could use a simple cut and paste to move the record from the one table to the next. If your tables are not exactly the same, then maybe you will want to consider another way. If they are, then this may be a very simple way.

2. YES / NO field
You could combine your marketing and member tables into one, and simply add a field called MEMBER. Make it a YES/NO field. Then modify your queries to filter based on this field. Over a long period of time, this redesign would save much time, provided you did it correctly.

3. ACTION QUERIES & MACROS
Lastly, you might consider using an update query to identify the record that exists in our Marketing Table, and then move it to the Member Table. You will need several update qeuries
strung together to create a process.
- Identify the correct records (Simple Query)
- Copy to other table (APPEND QUERY)
- Remove from original table (DELETE QUERY)
- Roll it all into one (MACRO).
This is the more complex solution, but, it can also save much time if designed correctly.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer