Feb 27 2006, 03:34 PM
On a report:
I need to add two individual groups of notes from two tables. Each note record has a note and a date in the table.
Currently when I enter data on either note tables (in a query), it multiplies the amount of records in each table for each note in the other table. If I enter in 3 records in table 1 and 3 records in table 2, I get 9 records in the query. I am using this query to base a report off it.
I need my report to show the following:
Customer A information
-note table 1
-note table 2
Is there another way to make these groups of data on a report without using a query? or how do I correct my query from showing 9 records when there are only 6?
Feb 27 2006, 03:54 PM
You are getting this result because the tables have not been joined on a common field, from your description it doesn't appear they have one. When two or more tables are placed in a query and NOT joined, then you get what is known as a cartesian product or cross product. Every record from each table is joined to every record in the other table. That is why you are getting 9 records.
It would be easier if you could put all the data into the same table, then there would be no problem. If that is not possible, then develop two queries, one to fetch from each table, and use them as subreports in a main report.
Edited by: fkegley on Mon Feb 27 16:04:15 EST 2006.
Feb 27 2006, 05:19 PM
If I combined the tables into one table how could I have two different groups of notes? I can't figure out how make more than one group at a time off one query.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here