need help adding more table to report 1

[KimVong]

I make this one report from table1, and would like to add another details from a different table, is there anyway to do that?

 

[CosmoKramer]

Create a query that has the desired table(s) and link them by their common key field(s). Use this query as the Recordsource for your report instead of a table.

 

[KimVong]

Hi CosmoKramer,
the reason why I'm having trouble becuase I'm trying to make a report that have a comparison for year 2003, 2002.
the the description relationship. And I want to rank the sales for each year.


like this

2003 2002
desc rank price desc rank price
a 1 30 b 1 31
b 2 20 c 2 21
c 3 19 d 3 12
d 4 18 a 4 0

you see, I would like my table to look like that in the order of rank for both year. But when I order by the rank in table 2003, the table 2002 doesn't sort in desc order like 2003, what's a good relationship that I need to set up so that I can have my report to look like above?
can you please help me?

 

[CosmoKramer]

If you want the two years to sort independently side-by-side, my first idea would be to create two subreports, one for 2003, the other for 2002 and insert them into a main report next to each other.

These subreports would not have to be linked to anything.

 

[KimVong]

I thought of that too, and that's what I did, but the problem with the way I did was, I wanted the one sub report right side of the page and the other on the left side of the page, how can I do that, I only know how to put a sub report on the bottom of another report.
thanks

 

[CosmoKramer]

You can place them next to each other in the detail section and it should work fine. I do it all the time; it's a great way to group related data in the same report....