Hi.
I'm new to this database world. Just started Access training a few months ago and have a somewhat complicated database already built. In a nutshell, I have a select query that uses a parameter callout so the user can enter a serial number of a widget and get test information for a report. The query pops out the test data in, for simplicity, in two columns, rest result Type A and Type B. The challenge for me is getting the results broken down into more columns. See, Type A testing is taken several times at different stages followed by Type B, the again followed by more Type A tests. The conditions of A and B tests are distinguished by TypeAID and TypeBID autonumbers which I can relate to operators, machines and conditions.
The other variation in the data is that widget 1 might have 2 As followed by 2 Bs then 1 A test as the norm. But occasionally, there is a need to retest so some widgets will have multiples of any of the Tests. Also, each test A and B are done in triplicate or more depending on the widget part number and all need to be reported.
For a single parameter entry of a SN, I'd like to be able to make a report that lists all these data in one column for each test condition and left to right by date. How is this type of operation done? Are there any special techniques I need to learn like macos or SQL code to get this done so its simple for the user? THANKS for any guidance. I hope I was clear enough to get a meaningful response.
TonyJH