I have been working a lengthy custom project revolving around custom VB apps and a SQL database.
I’m nearing the end and I have hit a brick wall.
I have created two views with data I need to populate my final report with.
The first view is Aquisition records, the second is disposition records.
For simplicity, each view has columns as follows
Serial_Number, Aquire_From, Aquire_Date
Serial_Number, Disposed_To, Disposed_Date
These views keep track of our Serialized Product during the production process. A serial number can travel several times between the plant, vendors, or customer returns. So there can be multiple entries in each view for the same number.
I would like to be able to merge these two views into a report as in the attached sample.
AS you see a serial number can have multiple transactions before being sold. If a serial number hasn’t been sold yet or no disposition has been made against it yet, the disposition is blank and is considered in our inventory.
Every transaction has a date associated with it (date/time to the millisecond). I haven’t been able to match records up to achieve this report yet.
Please let me know if more info is required.