Compare Tables MS Access 2007
Posted on 2012-03-21
Good Afternoon All,
I have two tables in an access database. The first table is tblCAD and the second table is tblPCR. I am trying to compare the field in tblCAD.IncNum to tblPCR eIncNum. The data is coming from a website. TblCAD represents CAD dispatches from our local 9-1-1 center. TblPCR is coming from a second website for patient care reports. Each is stored in a seperate table in access. The common field is IncNum. The CAD data comes down with an incident number attached. As the EMT completes the report he also enters the incident number as eIncNum in the tblPCR table. I want to compare the two incident numbers. If the incident number is in tblPCR matches the incident number in tblCAD then I know the report was completed by the EMS provider.
I do not know if it is possible but I would also like to see the Incident Numbers in tblCAD that have no match in tblPCR. I want to see both completed reports and uncompleted reports.
the CAD incident number comes down as 2012-85. The employee may or may not use the 2012. There report may show an incident number of 85 or 2012-85. So I am looking for this to pick up either match.
Any help would be greatly appreciated,