MS Access - Assistance with Query. Need Query built
Budget: $20 – $30 CAD
This is likely simple but driving me completely bonkers and need someone smarter in Access than myself to figure out. I included a spreadsheet of example data that I am working with.
Here is what I need.
Items are stored in the following format: ASL-XX-[Item Number]-[Country]-[Province/State if applicable].
For an example (also included in spreadsheet) we have Item number ASL-XX-220017-CA which denotes that this item is approved at the Country level. We also have ASL-XX-220017-CA-AB, which denotes that the item is approved for use in Alberta (Within Canada). The issue is that we are moving to the country level for all products and I need to produce a list of suppliers that need the ASL-XX-220017-CA assigned to them. The problem is that we have some suppliers that are currently approved for both items and some for only one type. Due to the naming convention, I am uncertain how to create a query that only displays suppliers that do not currently have the country level item assigned to them.
Supplier 30 in the example file requires the country level item to be created for them. Supplier 10 however has both the Country level and Province/State level already assigned.
I hope this makes sense. I would be more than happy to accept a screenshot and email showing the expression used in the query. If you could include a simple explanation on how the query works, I would highly appreciate it as well.
Here is what I need.
Items are stored in the following format: ASL-XX-[Item Number]-[Country]-[Province/State if applicable].
For an example (also included in spreadsheet) we have Item number ASL-XX-220017-CA which denotes that this item is approved at the Country level. We also have ASL-XX-220017-CA-AB, which denotes that the item is approved for use in Alberta (Within Canada). The issue is that we are moving to the country level for all products and I need to produce a list of suppliers that need the ASL-XX-220017-CA assigned to them. The problem is that we have some suppliers that are currently approved for both items and some for only one type. Due to the naming convention, I am uncertain how to create a query that only displays suppliers that do not currently have the country level item assigned to them.
Supplier 30 in the example file requires the country level item to be created for them. Supplier 10 however has both the Country level and Province/State level already assigned.
I hope this makes sense. I would be more than happy to accept a screenshot and email showing the expression used in the query. If you could include a simple explanation on how the query works, I would highly appreciate it as well.