I've merged two excel sheets and want to compare the side-by-side fields for each record (i.e. Agreement #, Start Date A and Start Date B) and show me the ones that don't match. How can I do this?
Novice
Windows 7 64bit 
Access 2007
I've merged two excel sheets and want to compare the side-by-side fields for each record (i.e. Agreement #, Start Date A and Start Date B) and show me the ones that don't match. How can I do this?
VIP
Windows XP Access 2010 32bit
You are linking to the sheet from Access?
Build a Select query on the linked sheet.
Include a calculated field: IIf([Start Date A] = [Start Date B],True,False)
Include a filter under this field for only the False values
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
One Report field in two side-by-side columns?
a bar on the side not wanted
same recordset subreport side by side
Multiple records side by side
Posting Permissions
Reply With Quote