manytables data in one report

[balu]

dear friends
i have many tables but i want all table data in a custamised way in one
report viz
table [invoice] (date,invoiceid(pk),invoiceddate,supplairid(fk),)
table [receivedinvoice] ( invoiceid(fk),fuelquantityreceived,)
table [decanteddata] (date,decantedid(pk
generatedkey),decatedtotank,tankbalencebeforedecant,tankbalenceafterdecant)
table[fuelissues] (date,issueid(pk),issuedquantity,issuedto)
table[misc issues] (date,misissueid(pk),purpus,misquantity)
these are the available data
The report recquired is
date(groupby,between specified dates),openingbalencesum
tankbalenceafterdeacnt - sum (
issuedquantity+misquantity)),totalreceivedinvoice:sum(fuelquantityreceved,between
date 00.00 hrs to next day 00.00
hrs),progrssivetotalreceivedinvoice:sum(fuelquantityreceived , between
startdayof month and now()),fuelclosingbalence at
cosing:sum(tankbalenceafterdecant - sum( issuedquantity + misquantity)
i traid to generate report in many ways but failed ,
1) kindly advise is im lapsed in table normalisation and setting up
relationship
2) how to do all calculations to for everyday in a month in one report
except fuelquantity and date remainig all data types are text
fuel quantity number
if any help offered may be sent to (e-mail address removed)
Please have a look at it please,