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 (which runs the comparison query). Basically once the user clicks the button, report should be opened with query result
2) Highlight the cells with different color having the mismatch in the report
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 (which runs the comparison query). Basically once the user clicks the button, report should be opened with query result
2) Highlight the cells with different color having the mismatch in the report