Two Sources - One Report

  • Thread starter Thread starter wmcgan
  • Start date Start date
W

wmcgan

I have a table that brings together the same data fields from two sources.
One source is actual data and the other source has the data with some changes
to certain fields to represent a "What If" scenario. I want to display this
information sid eby side in a report to see the effect of the changes.

I can create a report from each of the two sources that will give me what I
want but I cannot display them side by side with a column showint the
variances resulting from the data I have changed.
 
What if you create a query that joins the two tables on a common field?
Then, you can create a report from the query, and should have your data
available from both sources to show variances.
 
Chris, thanks for your reply.

I did create a database with all the fields. The problem is that when I
group the data in the report, the grouping groups the data together, based on
the field I cho0ose to group it on. Even if I have changed a field on the
record, it will be in the group for the field that was chosen regardless of
the data. Remember that all the fields are duplicated in the database with
the table name of the source as the difference in the name. even though the
data may be changed, it will still fall into the grouping of the field
selected to group by.

I am at a loss.
 
wmcgan said:
I have a table that brings together the same data fields from two sources.
One source is actual data and the other source has the data with some changes
to certain fields to represent a "What If" scenario. I want to display this
information sid eby side in a report to see the effect of the changes.

I can create a report from each of the two sources that will give me what I
want but I cannot display them side by side with a column showint the
variances resulting from the data I have changed.
Click to expand...


I think you should try to Join the two tables in the
report's record source query. If the two tables have the
same primary key values, it could be as simple as:

SELECT tbl1.*, tbl2.*
FROM tbl1 INNER JOIN tbl2
ON tbl1.pk1 = tbl2.pk2
 
Back
Top