Hello i have a report that with the fields:
Proposal Number Client Name Proposal Fee Status(won, lost, pending)
Code:
=Format$([Dated],"mmmm yyyy",0,0)
The report shows the Sum of the Fees
Code:
=Sum([Proposal_Fee])
here is where the problem begins
I want it to show the sum of the project won by each month, how ever i have no idea on how to make it work, since the coding i am using shows the sum of all the project in the form, of all years and month, here is the code
Code:
=DSum("[Proposal_Fee]","QryProposalInOrder","[Statu] Like 'Won*'")
is Statu because this fields shows the combination of the fields, the Status, and the Project Number of the Proposal
also at the end of the report i want the sum of the Yearly Proposals won(my guess is that having the monthly and yearly, the yearly would be the easiest to do
i need some help pls,
Thanks in advaned