JS Smith
New member
- Local time
- Today, 08:14
- Joined
- Mar 31, 2021
- Messages
- 15
Hi just starting to learn Access and Word Mail Merge. I couldn't find answer via Google. Nearest solution was the Next Record but wasn't sure how the syntax should read.
My Access Table is like the sample below. How can I use formulas in the Merge Fields to give me the «Project Contact» if the «Scope_of_Work» = Owner?
Thanks, as always, for an help you may provide!
My Access Table is like the sample below. How can I use formulas in the Merge Fields to give me the «Project Contact» if the «Scope_of_Work» = Owner?
CAM Project Number | Scope of Work | Amount in Numbers | Project Contact |
12345 | Architect | Pete Smith | |
12345 | Owner | $520,000.00 | Tammy Jones |
12345 | scope 1 | $1,800.00 | Mike Connor |
12345 | scope 2 | $1,800.00 | Jim Staples |
12345 | scope 3 | $11,000.00 | Jamie Cox |
12345 | scope 4 | $21,000.00 | Cindy Davis |
Thanks, as always, for an help you may provide!