Solved: Total in Report Footer ACCESS 2010 Report - Total NOT working

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

SlowHnds

Thread Starter
Joined
Mar 11, 2010
Messages
212
I have a very simple data base 3 tables

Product table with 2 fields productid and productdescription

Sale1 is the basic information of a sale invoice number and who items are sold to

Sale2 is the details and shows qty , item, price, and GST charged if any (some people or organizations are tax exempt so it becomes zero.

I've got my form and subform to run correctly

I've got my report to print all items correctly but I can't total the value

the line value for each item is a textbox

=Sum([QTY] * [Saleprice])*([GST])+([QTY] * [Saleprice])

This does return the correct value for that line item.

HOW can I correctly total the sum of all items into the reporrt footer???

HELP please the sale is tomorrow through Sunday.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Add a duplicate of your current calculating field and set it's "Running Sum" (under data tab) to yes overall.
Then in the footer use the new field as the totals Control Source.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top