Sum In A Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am trying to sum "Lines Quoted" based on the person's initials that is in
charge of working a particular project. I am using
=Abs(Sum([Lead]="MJ")*[Lines Quoted]) but the total is incorrect. What am I
doing wrong? Any help is appreciated.

Mark
 
Where is this control located? What's wrong about it? Maybe try:
=Sum(Abs([Lead]="MJ")*[Lines Quoted])
 
You must log in or register to reply here.

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

Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Running Sum 13
Reports for Yes/No Variables - Help! 3
Show SUM expression in text box 2
Report Equation Access 2003 6
Group last line of details and report footer 0
how can I caclulate the sum of a sum in a report? 2
sum error 2

Back
Top