Search results

Thanks Much! But i have a question. What if we have a text field instead of premium? How to capture that difference? Ex: Instead of premium, i have City field. And in source we have address as "ABC", and in target we have "XYZ". In this case, how to show the difference in the report?

Am uploading my access database CompareData button gives me the result of SRCData and TGTData tables in a datasheet view I have used union all query to compare as there is no primary key in tables Now i need a report from form, where the actual difference are highlighted in some color Just to...

Actually we don't have unique key in the table. And that is the reason, we use union all query. Could you please suggest some approach for this (through VBA or access in built options)

Ok. On conditional formatting in the report: Am using union all query to get the mismatched record. Even though there is a difference in one column, entire row will be fetched . Ex: One such mismatch is shown below Source data: SYSTEM,Policynumber, State, Premium Legacy,1234A123 ...

Sorry I didn't get you. How to do that? i need the form to be main interface from where reports or datasheets need to be displayed

Hi, I have a form which imports the excel spreadsheets as tables and display the mismatches in a data sheet view (Button control in form calls the comparison query) Now my requirement is: 1) To capture the data difference in a report by calling the report from button control in a form...