Query gives incorrect count of records

[Guest]

When I bringing info from 2 tables (194 total records), into 1 query the
total is 47,000 plus..Both tables have the same column headers, with the only
difference being one is from 2004-2005 and the other is from 2005-2006

 

[Douglas J. Steele]

What's the SQL for your query?

 

[Guest]

I have tried to use SELECT [Report Table04].[Week#] AS [Report
Table04_Week#], [Report Table04].AbsenceDate AS [Report Table04_AbsenceDate],
FROM [Report Table04] Join [Report Table04].[Week#] AS [Report
Table04_Week#],

 

[Guest]

SELECT [Report Table04].[Week#] AS [Report Table04_Week#], [Report
Table04].AbsenceDate AS [Report Table04_AbsenceDate],
FROM [Report Table04],
JOIN
[Report Table05].[Week#] AS [Report Table05_Week#], [Report
Table05].AbsenceDate AS [Report Table05_AbsenceDate],
FROM [Report Table05],

 

[Douglas J. Steele]

You haven't given a field (or fields) to join on, so you've getting a
cartesian product: each row in [Report Table04] is being joined with every
row in [Report Table05].

You need to join them on whatever key (keys) is (are) in common between
them.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

SELECT [Report Table04].[Week#] AS [Report Table04_Week#], [Report
Table04].AbsenceDate AS [Report Table04_AbsenceDate],
FROM [Report Table04],
JOIN
[Report Table05].[Week#] AS [Report Table05_Week#], [Report
Table05].AbsenceDate AS [Report Table05_AbsenceDate],
FROM [Report Table05],

What's the SQL for your query?