There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot browser bsod computer crash css dell desktop driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware help please hijackthis hjt hjt log install internet internet explorer itunes javascript keyboard laptop log malware monitor network networking openoffice outlook outlook 2003 outlook express password popups problem router seo slow sound sp3 spyware startup trojan usb video virtumonde virus vista vundo windows windows xp winxp wireless youtube
Archive: Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications > Archive: Business Applications >
{SOLVED} Access: Summing Reports


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
Guy's Avatar
Guy Guy is offline
Senior Member with 260 posts.
 
Join Date: Feb 1999
Location: abby, BC, canada
01-May-2001, 04:17 PM #1
I have a field in my report that I want to sum up in a footer but it will not let me. I named a field named [Regular] which has [Cost] * [Overhead] * [Taxes] as its control source (from a query). In the footer I have =Sum([Regular]) but when I run the report it keeps asking for [Regular].

Can this be done, or am I wasting my time?

- Guy

[Edited by Guy on 05-02-2001 at 11:10 AM]
downwitchyobadself's Avatar
Senior Member with 943 posts.
 
Join Date: Oct 2000
02-May-2001, 09:20 AM #2
It sure can, and in lots of different ways. There's just one thing I don't understand in your post: is the field in the underlying query called CostConv? Or is the control on the report called CostConv? And what's regular?

In any case, if you're summing in the report's query, let's say, you have a field called SumWithTax, which is the result of the calculation cost*overhead*tax. Then you can put in the footer control a control source of =Sum(SumWithTax). But if you're calculating in the control on the report, i.e. your control source reads something like

=[MyCost]*[MyOverhead]*[MyTaxes]

or however you're working it, then your sum needs to match it:

=Sum([MyCost]*[MyOverhead]*[MyTaxes])

I'm assuming that you've told it to sum the control, which is not quite the same thing; only controls' data can be totaled.

Otherwise, check out the RunningSum property in Access help, and so on, for other possibilities.

Hope this helps.
__________________
complicated music button
Guy's Avatar
Guy Guy is offline
Senior Member with 260 posts.
 
Join Date: Feb 1999
Location: abby, BC, canada
02-May-2001, 11:08 AM #3
Sorry
Sorry, I used 2 different names for the same thing. Okay, I have a query with 2 fields: Cost and Hours. In my report I have 2 text boxes: Hours and Cost. If I put in my footer =Sum([Hours]) and =Sum([Cost]) then I get the totals that I want.

But, if I name one of the text boxes to 'CostPlus', for example, and In the text box I have [Cost]*13.5 as the control source. Then I put =Sum([CostPlus]) in the footer, i get prompted to input CostPlus when I run the report.

What you are saying is that I have to put =Sum([Cost]*13.5) in my footer, correct? Is there anyway to get around this (Ive tried doing my calculations in a query but I gave up on that)?
downwitchyobadself's Avatar
Senior Member with 943 posts.
 
Join Date: Oct 2000
02-May-2001, 11:24 AM #4
The way to get around it is to do your calculations in your query. When you tell Access to do a sum, it assumes you mean a sum of a field; a control is a shell around data, not data itself, if that makes sense.

But if you add, in a new column in the query, the following text

CostPlus: [Cost]*13.5

then save the query, you'll get a field called CostPlus, and you can then put =Sum([CostPlus]) for the control source of the report footer control.

There is no way "around" it because you're confusing report (or form, for that matter) controls with data fields.
Guy's Avatar
Guy Guy is offline
Senior Member with 260 posts.
 
Join Date: Feb 1999
Location: abby, BC, canada
02-May-2001, 08:29 PM #5
Thanks
I got it now by doing my calculations in a query. Thanks.
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 04:15 AM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.