Queries and Forms Put Together

L

Luis

I do not think I can, but if anybody know...please help:

I have two queries showing like this:

1.
Procedure Code Drug Name Type Number of Profit Total
Injections Profit
LMOBG122 H305 Tylenol Drug 2 $3 $6
LMOBG122 H125 Advil Drug 3 $1 $3

2.
Procedure Frequency Number of Profit Total Profit
Treatments
LMOBG122 3Weeks,10 times 10 $100 $1,000

I need to put this information in a report...Can I do
this? How do I put two reports together...

Thank you so much.
 
L

Luis

I got it...I used subreports...
-----Original Message-----
I do not think I can, but if anybody know...please help:

I have two queries showing like this:

1.
Procedure Code Drug Name Type Number of Profit Total
Profit
LMOBG122 H305 Tylenol Drug 2 $3 $6
LMOBG122 H125 Advil Drug 3 $1 $3

2.
Procedure Frequency Number of Profit Total Profit
Treatments
LMOBG122 3Weeks,10 times 10 $100 $1,000

I need to put this information in a report...Can I do
this? How do I put two reports together...

Thank you so much.
.
Click to expand...
 
Top