Getting particular Values into the Report From Main Table & Sub Table

R

Rekha

Hi,
I have 2 tables & built a relaionship on the ID which is
autonumber. There are different deposit_dates on this
main table corresponding to which I have all the required
info in the SubTable. I have a Report based on the Main
Table. Now, this Report should display the items on the
Main Report with respect to the deposit_date & also the
corresponding items of the SubTable on which a Sum
function should be used to add all the amount of the
SubTable_Amount. Right now since I've put the text box for
deposit_date in the page header and the rest of the fields
to display in the Details section, it shows me on one
deposit_date all the records which I don't want but only
the info corresponding to that particular date. Please HELP
 

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

Filtered Report from multiple tables 6
Autofilling value in Table??? 1
Hide subreport and main report record if subreport running sum is zero 9
Report with pivot tables and pivot charts in sub reports 7
Showing subreport value in main report page header 3
Trouble with sub-report to main report 0
Using queries from multiple tables to create a report 2
Printing of sub-report skips to second page. 7

Top