I am building an Access database to automate the printing of COA's. I have one table (table 1) of the test data 50+ tests, and one table (table 2) of what specific tests specific customers require. I need to build a query that will show me the only the test results for the tests required by a specific customer. So I need the tests specified in a query of table 2 to become the field names in a query of table 1. Does any one have and example of how something like this can be done? I am fairly new to writing code, so I may need a bit more explanation of the code.
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts. The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.
Our data is constantly exposed to the danger of being intercepted or stolen as it wends its way over global data networks. Data security measures and measures for protecting intellectual property should not, however, first be implemented when data is exchanged – companies must lay the foundation for these measures within their own organization. Download Now
The influence exerted by the Internet of Things (IoT) means that there is a steadily growing need for collaboration in industry. Partners from new industries and areas of application need to be integrated in cross-company business processes to ensure that the lifecycle of smart, connected products can be managed from end to end. Download Now