Table1 would have say records called Sample001, Sample002 and so on. on table two i would like to have a query that showed all the records from table1 and a text box that had just a comments sections where a quality control comment could be left. this would be about 1 out of every 100...
Basically, i have a SampleNumber in table1 that has most of the data i need. In table two, i would like to list all of the sample numbers from Table1 and be able to leave a text field comment on any sample number within any of those sample numbers on a randomly selected basis. In access...
Hello,
I am trying to upgrade my current system to sql/adp.
I cant seem to get two table to work together in a query.
In Table A is where when a sample comes in it gets entered into the system. Sample Number And Date Arrived are two columns. Table B has more columns depending if the sample...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.