Morning,
Looking for a little advise and help. I have created a Access Db that contains 3 tables and one query.
The 3 tables are:
As you can see the above is very messy and I been told I can achieve a better solution in VBA.
Here is the criteria I am trying to solve for:
Any help and or advice is gratefully accepted.
Thanks
Looking for a little advise and help. I have created a Access Db that contains 3 tables and one query.
The 3 tables are:
- Job Types
- Sent items
- Remote Jobs
- Sent.Subject
I am searching in the content of the field to see if it has a keywork or list of keywords that I am looking for. - Position – I am creating this field in the query that I am creating and in this field I am using the following to find a keyword then print the keyword found.
- Example:
As you can see the above is very messy and I been told I can achieve a better solution in VBA.
Here is the criteria I am trying to solve for:
Scrum Master | Scrum Master |
Project Manager, Digital Project Manager, Project Mgr. | Project Manager |
Program Manager, Program/Portfolio Manager | Program Manager |
Product Owner | Product Owner |
Product Manager, Product Management, | Product Manager |
Agile Coach | Agile Coach |
Change Management | Change Management |
Test Lead | Test Lead |
Delivery Manager | Delivery Manager |
Business Analyst, Analyst, Discovery, | Business Analyst |
Delivery, Delivery Lead, Delivery Manager | Delivery Lead/Mgr. |
Thanks