data Match Query

[GirlBlonde]

Hi i am having a problem running a query that compares last months data to this months data. the tables are the same i just want to see if changes have been applied in the new months data.

i am running a query extracting the information using a cardno field that is in both of the tables, but even though i am linking this field i am getting over 90,0000 records when both the tables only have 1200 odd records each.

shouldnt it just give me the details for all card no that are the same in either table? i do not understand why i am getting this. can someone please help shed some light on this for me? i am using access 2007.

Energy & persistance conquer all things!

 

[dhookom]

Can you provide your SQL view(s)?

Duane
Hook'D on Access
MS Access MVP

 

[GirlBlonde]

hi this is the query SQL

SELECT CarParkingList.Building, CarParkingList.BuildingText, CarParkingList.CardNo, CarParkingList.Occupant, DataComparisonTble.BuildingText AS lastMthBuildingText, CarParkingList.Building AS lastMthBuilding, CarParkingList.Occupant AS lastMthOccupant, CarParkingList.cardno AS lastMthcardno
FROM CarParkingList INNER JOIN DataComparisonTble ON CarParkingList.CardNo = DataComparisonTble.CardNo;


Energy & persistance conquer all things!

 

[dhookom]

Are the CardNo fields the primary keys of both tables?

Duane
Hook'D on Access
MS Access MVP

 

[JoeAtWork]

My guess would be that there are many duplicate CardNo's in either or both the tables.

Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[GirlBlonde]

hi

yes as this is just starting to get in order there are duplicates in the card no field, i am trying to eliminate this. i will then make it a primary key. is this why?

Energy & persistance conquer all things!

 

[dhookom]

Yes, duplicate values are causing multiple extra records.

Duane
Hook'D on Access
MS Access MVP