Search results for query: *

Success! Now on to the reporting/excel export. I'll poke at this for a while. MajP, I can't thank you enough!

Wow, you rock. I'm going to play with this code until I get it working. I'll keep you posted.

Majp, I should mention all the fields are either type number or text. The PK is text for example. This app basically imports two excel sheets, the old and new. The data types where assigned automatically on importing, I reckoned. I'm playing with the code now and trying to troubleshoot a data...

Majp, I will soak this in and play with it. I'll get back to this thread afterwards. Again, I truly appreciate the help. No way I could of even come close to this! Alex

Thank you!

MajP, thanks for the idea! Q1: Any chance you could post a few records? There are 108 columns so it's hard to post but here is a small sample (I added RecordType as you specified): tblA (NID is key): RecordType | Department | DName | Title | Ri | NID Old | 00094 | CNDS |...

MichaelRed - but why is it being sent to excel? surely it can only be for review / information? so doesn't an Access report provide the same utility?" - Ideally I would like to provide both an Access Report and Excel export. The thing with the report is how can I handle 110 columns? With...

oops sorry for the extra line at the bottom..

OKay, I made a query that would output the rows and fields like I wanted. It lists the rows which have changes (showing only two fields for brevity): SELECT tblA.* FROM tblA RIGHT JOIN tblB ON tblA.ID = tblB.ID WHERE tblA.[Field2] <> tblB.[Field2] OR tblA.[Field3] <> tblB.[Field3] UNION...

First post. Hi all! I have two tables both with identical column structure (110 columns). TableA has old records and TableB CAN have updated records or not. They have the same key in both tables. Field types are the same in both tables and there are null values in both. TableA: ID | F1 |...