Hi everryone
I am working on a system for recording lab sample results, so far I have created tables, forms and queries to input the data and this works OK. What I would ideally like to do now is create a query to list all the samples that are due for reading to be listed in order of TestStageID.
The tables I have are LabSamples containing details about the sample, TestStages containing all the different test stages and a Results to enter all the readings.
Each sample can have multiple TestStages and these are not the same for each sample. This means that TESTA can be selected as a 1st test for one sample but a 3rd Test for a different sample.
Hope this makes sense
Nick Fazer
I am working on a system for recording lab sample results, so far I have created tables, forms and queries to input the data and this works OK. What I would ideally like to do now is create a query to list all the samples that are due for reading to be listed in order of TestStageID.
The tables I have are LabSamples containing details about the sample, TestStages containing all the different test stages and a Results to enter all the readings.
Each sample can have multiple TestStages and these are not the same for each sample. This means that TESTA can be selected as a 1st test for one sample but a 3rd Test for a different sample.
Hope this makes sense
Nick Fazer
