ACCESS REPORT

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

Guest

I have a table with teo columns "copy type" and "sumofto total quantity". I
created a report wwith 3 columns with the following statement under each
column; =IIf([Copy Type] Like "Distr",[SumOfTotal Qty],""), ans in the other
2 clumns I've replaced "Distr" with "Store" and "Overs".
I would like to total the three columns in my report footer so I created
another statement as followes; =IIf([Copy Type] Like "Distr",Sum([SumOfTotal
Qty]),"") and in the other 2 columns again I've replaced "Distr" with "Store"
and "Overs".
When I run the report no error message is returned but no total show up.
What is wrong with my totals statements?
Thanks, John
 
At least one reply in another news group where you asked the same question.
 
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

summing in report 1
Total currency column in report 3
SUM on alias in a REPORT 1
Access Query problem 1
Time in calculated field for shifts going past midnight 0
Crosstab query help please 1
Format field to Percent w/ 2 decimal places using IIF statement 3
IIF Statement Problem 7

Back
Top