I am really new to access and think I have grabbed several of the basic concepts, however please be gentle!
I need to collect lab testing data of several differing products, and be able to print this data on a certificate of analysis:
eg.
Product: a
Batch Number: b
Date:
Test 1:
Result: c lower limit w upper limit x
Test 2:
Result: d lower limit y upper limit z
Where a certificate will have different limits depending upon the specification for each of seperate products.
I (think!) I am able to create a table etc to collect the relevant data, but if someone could guide me through the basic steps to get the relevant data on a certificate I'd very much appreciate it.
I guess I'll have to make a word certificate, and reference lookup fields but I'm not really sure how to go about this. I have very limited ability with VBA and SQL code.
Any help is really appreciated.
Many thanks in advance guys!
Frosty.