Creating a Query from a Query

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

I'm trying to create a Query from 2 separate queries. 2
fields are the same, and 1 is not. When I try to do the
query, It turns what should be 72 records into 1741
records. Any ideas?
 
As a guess, you don't have a join specified. Or if you do have join specified
then there are multiple matches between the two tables.

If you have
TableA with
A
A
A
B
C

And TableB with
A
A
A
B
C

The join on the field will produce
9 records based on A value in TableA matching the A value in TableB, plus one
for the B and C matches for a total of 11 rows.

If you don't have a join specified you will get a Cartesian Join of 25 records
returned. One for each combination of the five rows in each table.
 
You haven't given us enough information.

Are there any relationships you can use to join the 2 Queries or you simply
want the 3rd Query that returns the rows from Query1 plus the rows from
Query2?

If this is the case, the 3rd Query will probably need to be a Union Query.

Check Access Help on Union Query.
 
Back
Top