Hi there,
I've been trying to create a query to like the production BatchID to a Samples record based on when the samples were taken.
BatchID is when a batch of pencils have gone through a machine (i.e. what type of pencil, its Shop Order and Release No's, Start Date and End Date).
I have attached an Excel File where I have drawn out the two tables I want to link with some sample data, and I have drawn the query I want to achieve.
Any help on this matter will be greatly appreciated as im loosing it now!
Thanks in advance
Stuart
I've been trying to create a query to like the production BatchID to a Samples record based on when the samples were taken.
BatchID is when a batch of pencils have gone through a machine (i.e. what type of pencil, its Shop Order and Release No's, Start Date and End Date).
I have attached an Excel File where I have drawn out the two tables I want to link with some sample data, and I have drawn the query I want to achieve.
Any help on this matter will be greatly appreciated as im loosing it now!
Thanks in advance
Stuart