Search results

So, is there a way to assign an order number to each and every one of the install and deinstall records based on chronological sequence? For example: Table1: serialX installdate1 order1 serialX installdate2 order2 serialX installdate3 order3 Table2: serialX deinstalldate1...

I have tried the left join option, and I still got the same results i.e. 2 deinstall date's for each install date. Attached please find an Access db containing the two sample tables mentioned in my original post. Thanks for all your quick responses! Regards, AndyL

Hello all, I have two MS Access tables; table1 contains installing records (fields = serial, installdate) and table2 contains de-installing records (fields = serial, deinstalldate). Tables are structured as followed: Table1: serialX installdate1 serialX installdate2 serialX...