I have created a DB with many tables and I want to find a way where I can retrieve all the emails from every table (each one has a column with emails). Does anyone know what to do? If a record doesn't have an email address do I have to type N/A or just leave it blank?
find all the emails
- Thread starter GeorgeChr
- Start date
ted.martin
Registered User.
- Local time
- Today, 14:47
- Joined
- Sep 24, 2004
- Messages
- 743
You need a new table called e-mail which is where all the addresses will be stored. Create a Make Table query and then a series of Append queries for the other tables. You can then create one macro to run the Make Table query followed by all the Append queries. You will then have one new table reporting all the e-mail addresses.
To omit the blank ones just include a filter in each query that is <> ""
To omit the blank ones just include a filter in each query that is <> ""
