many table in one report

B

balu

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),closingbalence:(sum(onhandbalence+actualquantity))-(sum(fuelissues+miscellaniosissues)) In one report
dear sir is it possible how to do it please
 
H

Haze1023

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.
 
B

balu

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
Haze1023 said:
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.

balu said:
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),closingbalence:(sum(onhandbalence+actualquantity))-(sum(fuelissues+miscellaniosissues)) In one report
dear sir is it possible how to do it please
 

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


Top