Dear Sir
I have two table in MS Access 2007 as the image shown below. In these two tables the Fields---Total number of pregnant women Registered for ANC, of which Number registered within first trimester(within 12 weeks), New women registered under JSY (out of total ANC Registrations (item 1.1 women registered under JSY), and 3rd Check up of Table 1 are same with the fileds---Total number of pregnant women Registered for ANC, of which Number registered within first trimester(within 12 weeks), New women registered under JSY and Number of Pregnant women received 3 ANC check up of Table 2 accordingly. Now, my question is-- How can I find out the data discrepancy from these two table by using query with field name and I want to extract the result in another excel sheet.
Regards Atul Saikia. |