many table in one report

[Guest]

dearsir,
how to establish relationship and normalise to get the report for the tables
below viz.[fuelinvoces]
field invoiceid 'text' (PK)
" invoceddate 'date/time'
" invoicedquantity 'number'
" actual quantity ' number'
" decanted storagetankname ' text'
table [storagetankdata]

field decantingid 'autonumber'(pk) ,,(i have not found any altarnative id )
" tankname
" tankmeasurement beforedecant 'number'
" tankmeasurementafterdecant 'number'
" invoiceid 'number'
" decanteddate 'date
table [fuelissues]
field issuedate 'date'
" isuueid 'text'(PK)
" enginenuber 'text'
" tankname 'text'
table [miscellaniousissues]
field misissueid 'text(PK)
" quantity 'number'
" purpus 'text ,, (any purpus like foe
gensets)
" tankname 'text'
now i want the one report [date],
[tankname],[onhandbalence],groupbyof[fuelinvoices]"all details of that
day",(sum(onhandbalence+actualquantity)),groupbyof(fuelissues),groupbyof(miscellaniousissues),closingbalencesum(onhandbalence+actualquantity))-(sum(fuelissues+miscellaniosissues)) In one report
dear sir is it possible how to do it please

 

[Guest]

Are all of your tables setup in the relationship? If they are you should be
able to select fields from multiple tables when using the report wizard.
Or you could create a query to combine all of the data into one table,
including your calculated fields and then create a report based off of the
query.
Also if you are linking the table you have 2 different field types listed
for InvoiceID, one is a number and the other is text.

 

[Guest]

im extremly sorry for wrong information please sir,
the invoice id is purely textfield
and what im expecting is the how to normalise the table relationships to get
the desired out put i mean the report .please sir kindly advise me to
establish the relationship and any further breaking up of tables necessary
and also advise me an code to open an perticular exl file on click of an
command button which can open an exl file which is in the MYdocuments ,
my email is (e-mail address removed)
THANKS FOR YOUR KIND HELP
YOURS

Are all of your tables setup in the relationship? If they are you should be
able to select fields from multiple tables when using the report wizard.
Or you could create a query to combine all of the data into one table,
including your calculated fields and then create a report based off of the
query.
Also if you are linking the table you have 2 different field types listed
for InvoiceID, one is a number and the other is text.

dearsir,
how to establish relationship and normalise to get the report for the tables
below viz.[fuelinvoces]
field invoiceid 'text' (PK)
" invoceddate 'date/time'
" invoicedquantity 'number'
" actual quantity ' number'
" decanted storagetankname ' text'
table [storagetankdata]

field decantingid 'autonumber'(pk) ,,(i have not found any altarnative id )
" tankname
" tankmeasurement beforedecant 'number'
" tankmeasurementafterdecant 'number'
" invoiceid 'number'
" decanteddate 'date
table [fuelissues]
field issuedate 'date'
" isuueid 'text'(PK)
" enginenuber 'text'
" tankname 'text'
table [miscellaniousissues]
field misissueid 'text(PK)
" quantity 'number'
" purpus 'text ,, (any purpus like foe
gensets)
" tankname 'text'
now i want the one report [date],
[tankname],[onhandbalence],groupbyof[fuelinvoices]"all details of that
day",(sum(onhandbalence+actualquantity)),groupbyof(fuelissues),groupbyof(miscellaniousissues),closingbalencesum(onhandbalence+actualquantity))-(sum(fuelissues+miscellaniosissues)) In one report
dear sir is it possible how to do it please