joining data from two reports

hello - am attaching sample database-
I have two reports- report1 and report2
originally created seperately- now being asked if I can join the data to display together-
in this way:
Category   item code    item description     YTD   JAN   etc.....

Best Buy     401          monitor            125    10   etc.....
 ( adding data from rpt2- that matches category right below)
             14          monitor part 1      60     10   etc...
             17          monitor part 2      90     15   etc...

HP           201          scanner            110     9   etc...

             143          scanner part 1     85      15  etc..
             144          scanner part 2     40      40  etc..

Is there anyway to have this data display like this -W/ form&subform?
thank you--

( rpt 1 based on tbl1/tblCategory/ and tblFinancial)
( rpt 2 based on tbl2/tblCategory2)
DataSample1.accdb
davetoughAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Here is what I came up with:

see: rpttbl1
DataSample1.accdb
0
 
davetoughAuthor Commented:
what I did not mention is that tbl1 and tbl2 are seperate tables in different db's- that are being updated daily- maybe I should join tables in a this db to create 1? an have some type of update process- keeping table up to date?
0
 
Jeffrey CoachmanMIS LiasonCommented:
At the very least you would have to have the ItemCode in both tables.
You do, but the values do not match between the two tables?

If they did match, then you could create a simple Grouped report
*However* your tables have a slightly "un-normalized design" with "Months" as fields instead of Rows.
You also have the same fields in both tables (this is rare in a One to Many relationship)

Finally, neither table has a primary key, this further complicates the task of joining the data.
0
 
davetoughAuthor Commented:
thanks for your help
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
All Courses

From novice to tech pro — start learning today.