Queries and Forms Put Together

  • Thread starter Thread starter Luis
  • Start date Start date
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Blank Totals 2
Correct Nz syntax when summing? 4
How do I create a Profit Report from one-to-MANY relationship? 1
Grouping and sorting fields in a query 5
Query help please. 3
Query on Query - put results onto report? 5
Custom report needed with line for every day of month, regardless of whether or not data exists for 7
need help with report and pretty much everything. 1

Back
Top