About Geoff Expertise I specialise in database analysis and design, SQL and database queries using QBE and VBA. In my work, I use MS Access together with MS SQL Server as ETL (Extraction - Transformation - Loading) tools for migrating data between business ERP systems and data stores. My forte is building bespoke functions and applications.
See my
website for example apps and downloads
Experience I am a chartered engineer with 30 years of engineering and business experience, member of the BCS and have been working specifically in database applications, including SQL Server (v7/8/2000) for the last 9 or so years. I previously taught a course in Database Analysis and Design, but am now a freelance consultant and systems analyst.
Commercial database design and development work undertaken.
Using MS Access - Printing labels - adding to existing mailing list
Expert: Geoff - 5/6/2009
Question I have a mailing list of over 1700 names, just recently our post office informed us that we need to add "or current resident" to each label to send bulk mail.
How do I add "or current resident" to an existing mailing list using MS Access?
Answer Sherry, hi,
You should be able to amend the query that feeds the mailing list, with an extra constraint.
SELECT Name, Address1, Address2....
FROM .....
WHERE ....
becomes
SELECT Name, Address1, Address2....
FROM .....
WHERE (....) OR ... = "Current Resident"
(or something like that)
Sorry I can't be more specific, but there's not a lot to go on...
