Find out the Data discrepancy between two tables(in MS Access 2007) by using  query.

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.

September 19th, 2013 6:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics