make conditional total in report (1 Viewer)

[mobarak ahmed]

hi , 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 !

 

[mobarak ahmed]

Up

 

[Gasman]

Reposting the same post as a new thread, is not going to get you there any quicker, in fact it might limit the responses.

 

[mike60smart]

Up

Hi Mobarak

Is this what you are after?

If it is then all you need as the record source is Query3 - Group by Project Type, Customer & Project

 

[mobarak ahmed]

Hi Mobarak

Is this what you are after?

If it is then all you need as the record source is Query3 - Group by Project Type, Customer & Project

That is exactly what i want please send me file after update

 

[mike60smart]

Hi Mobarak
Check and see if this suits.
I modified your Query3 and removed all of the Criteria you had set.
I then added Criteria to the Click Event for the Command Button to Open the Report.

 

[mobarak ahmed]

Hi Mobarak
Check and see if this suits.
I modified your Query3 and removed all of the Criteria you had set.
I then added Criteria to the Click Event for the Command Button to Open the Report.

thanks for your effort but you have made a lot of changes which i don't need to
but how you create project name footer ? so if putting sum cell on it is the solution i will give it a try

 

[mobarak ahmed]

Up

 

[mike60smart]

What does Up mean ?

 

[Gasman]

What does Up mean ?

@mike60smart I believe it means the o/p is bumping the thread and still waiting for someone to write all the code for him, in the way that he wants it written.?

 

[mike60smart]

Hi Gasman
Well I gave him code to do what was required and it displays his report in the format requested, so he will wait a long time to get another answer.

 

[mobarak ahmed]

Sorry mike if my reply bother you ,,
i am brand new access user
so i have searched a lot to figure out how you creat project name footer but I didn’t find anything
You have removed a lot of criteria that i need
So i need to know how you add project name footer in order to make only small change to achieve what i need

 

[mike60smart]

Can you give us some idea as to what it is you want when you "add project name footer"??

 

[mobarak ahmed]

Can you give us some idea as to what it is you want when you "add project name footer"??

i assumed that when i put the calculation of sum in the footer of the project it will take the project as criteria !

 

[mike60smart]

Sum only sums the values for a specific Project and these are the calculations currently in the Report

What values do you want in the Footer of the Report ?