Query not providing correct number of entries

[mpreston14]

The saga continues with my database...

I have imported several files into a table and using an append query upload those to a master table with a score calculated in the query as well.

When I run the query it only is giving me 1711 of 1827 known records.

I have looked at format and all the files that are text are text and numbers, numbers, dates, dates etc so I am stumped.

here is the SQL from the query:

INSERT INTO Officiated_Matches_T ( Points )
SELECT Import_SL.*, [Match].[MatchMultiplier]*[League].[LeagueMultiplier]*[Position].[PositionMultiplier] AS Points


FROM [Match] INNER JOIN (Referee_T INNER JOIN ([Position] INNER JOIN (League INNER JOIN Import_SL ON League.League = Import_SL.League) ON Position.Position = Import_SL.Position) ON (Referee_T.LastName = Import_SL.LastName) AND (Referee_T.FirstName = Import_SL.FirstName)) ON Match.Match = Import_SL.Match;

I am sure it is something easy but the I look at it and rebuild over and over the more frustrated I get....

Thank you in advance for your help!

Mike

[pbaldy]

Almost certainly an issue with the joins, like the main table has a position that the position table doesn't have, or referee, etc.

[mpreston14]

It turns out it was a combination of joins and the data itself. The data files contained entries from another state that did not match our referee listing. I created a query to find the mismatches and then the matches. I then made changed the joins and it worked spot on...it took way to long to figure that out...sometimes when you work on something too long you just cant see the easiest solution!

SOLVED.

[pbaldy]

Glad you got it sorted out.