Need Help to Make a Report

  • Thread starter Malik via AccessMonster.com
  • Start date
M

Malik via AccessMonster.com

Hi.
I m in deep Trouble to creat a Report. For This report i have 4 Queries. Now
I want to creat a Ledger Report. How to Make the report as Follow


-----------------------------------------------------------------------------
--------
---------
TransactionID CR DR
BALANCE
------------------------------------------------------------------------------

-------
---------
Field from QuerySaleId(from Query 1) 233.00 233.
00 cr
Field from QueryDrvoucher(From Query 2) 33.00 200.00
cr
Field from QuerySaleId( From Query 3) 500.00 700.00
cr

And So On

I want to run queries Seperately bcus A union Query do not meets my
requirements

Thanks
 
M

malik via AccessMonster.com

------------------------------------------------------------------------------
-------------------------
TransactionID CR DR
BALANCE
------------------------------------------------------------------------------
------------------------

Field from QuerySaleId(from Query 1) 233.00 233.00 cr

Field from QueryDrvoucher(From Query2) 33.00 200.00 cr

Field from QuerySaleId( From Query 3) 500.00 700.00
cr

And So On
 
M

malik via AccessMonster.com

------------------------------------------------------------------------------
-------------------------
TransactionID CR DR
BALANCE
------------------------------------------------------------------------------
------------------------

Field from QuerySaleId(from Query 1) 233.00 233.00 cr

Field from QueryDrvoucher(From Query2) 33.00 200.00 cr

Field from QuerySaleId( From Query 3) 500.00 700.00 cr

And So On
 
M

malik via AccessMonster.com

------------------------------------------------------------------------------
-------------------------
TransactionID CR DR
BALANCE ----------------------------------------------------------------------
-------------------------------

Field from QuerySaleId(from Query 1) 233.00 233.00 cr

Field from QueryDrvoucher(From Query2) 33.00 200.00 cr

Field from QuerySaleId( From Query 3) 500.00 700.00 cr

And So On
 
M

malik via AccessMonster.com

------------------------------------------------------------------------------
--------------
TransactionID CR DR BALANCE
------------------------------------------------------------------------------
--------------

Field from QuerySaleId(from Query 1) 233.00 233.00 cr

Field from QueryDrvoucher(From Query2) 33.00 200.00 cr

Field from QuerySaleId( From Query 3) 500.00 700.00 cr

And So On
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
union query 2
optimized way to make a report? 14
Changing a 'Static' report to a 'Dynamic' one 5
Formatting question - make table query 2
Moving data from a report to a form 4
Need to make IIF stmt work in text box with expression 3
help to write query 0

Top