Sum of Report

[tirfan]

Dear Access Experts,

i have a field called "Site Code" and base on this site code Access Extracting Data from other table and displaying Projectvalue of Each site. and in other table we are inputing data of each payment Certificate under every site. some time we submit more than one payment in each month for a site. how we can sum of the project value.


SiteCode Project Value. Payment No. Gross Amount
8456 123456 1 10
8456 123456 2 15
8456 123456 3 10
_______________________________________________
Total 123456 35


but please keep in mind. our Report format is Approved from our client which is attached, (Tabular). i can not change the format of report.

[June7]

You could try the HideDuplicates property of textbox to prevent repeat of the data. However, the Total should be unaffected. Might have to do the Total Project Value as a DSum in textbox ControlSource.

Have you attempted building the report? If you want to provide project for analysis, follow instructions at bottom of my post.

[tirfan]

Yes i have hide the duplicate, but as you mention its not effecting the Sum of Total value. how we can use Dsum? can you help

[tirfan]

As per your instruction, file has been attached. kindly provide help to solve the problem

[June7]

Try:
=DSum("[Budget]","QueryBudget")

[tirfan]

Thank you very much. my big Problem have been solved