sorry but i need help to apply what you say , the database is attachedYour sum control should be in the group footer and it's running sum property should be over group.
Oh no it isn'tsorry but i need help to apply what you say , the database is attached
Mr arnelgp is always helpful in this issuehi , i have a report named " ReportCustomerProject " it should show all projects in one page sort by
1- project type
2- customer name
3- project name
and it should show the sup total of every project but now the total text box shows total of all projects under every project
any help or advices !
I am brand new access user but i am trying to do my best by see tutorials and ask friends here and thereIn the attachment you can see the example where I took the liberty of modifying the Data Source of the subform which is now given by Query3 without the need to set all those conditions as in the QryReportSubCustomerProject. Furthermore, I would like to point out that the database structure is not correct as it has data redundancy, lack of management of the fundamental properties of the fields (Required and Indexed type), etc ...
unfortunately No .. you have made changes in form that I don't need and the "projects report" button is not workingYes, but the attachment satisfied your request.