473,320 Members | 1,580 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

report footer sum of value in a combo box

Hi all,
I'm hoping someone can help me out with an Access 2003 project. I'm at the final stages of my project and have ran into an issue with developing the report.

I have a report that uses combo boxes to pull from related tables, and one of those related tables (named "Biz") has a field called "calc_value" that has a number I need to both show on the report in the detail and to be summed in the group footer and the report footer. That number is pulled from a combo box on the report named "BizB" which pulls data also needed on the report from the relational table.

On the report, while I can get the detail to extract the "calc_value" (in the report detail section, made a text box with the control source "=[BizB].[Column](2)"), I cannot get the sum to work.

In the report footer, What is the formula to put in the text box to sum the detailed "calc_value"?

I have 3 sample data records:
line 1 calc_value = 55.00
line 2 calc_value = 64.30
line 3 calc_value = 14.25

The sum I should be seeing in the group/report footer with the sample data here should be 133.55.

For purposes of this report, the text box in the detail that shows the number I need to sum is named "calc_value".


I have tried:
=Sum([calc_value])
That didn't work. Nothing was returned; empty box.

=[BizB].[Column](2)
That didn't work. Nothing was returned; empty box.

I also tried
=Sum([BizB].[Column](2))
Which caused the report not to run; got this error instead:
Undefined function "[BizB].[Column]" in expression

Thank you all. I really appreciate it!
Apr 29 '13 #1
3 1254
NeoPa
32,556 Expert Mod 16PB
What's the name of the control in the detail section with a formula of "=[BizB].[Column](2)"?

The formula in the totals control should be "=Sum([That])".
Apr 30 '13 #2
I've done 3 different attempts. The name of the text box with the formula is "calc_value".

For purposes of this report, the text box in the detail that shows the number I need to sum is named "calc_value".


I have tried:
=Sum([calc_value])
That didn't work. Nothing was returned; empty box.

=[BizB].[Column](2)
That didn't work. Nothing was returned; empty box.

I also tried
=Sum([BizB].[Column](2))
May 1 '13 #3
NeoPa
32,556 Expert Mod 16PB
You have both the field and the control called [calc_value], yet it doesn't work to say =Sum([calc_value]) in the footer? That seems weird to me. I've used that successfully before with a TextBox control. Maybe it doesn't like that it's a ComboBox.

If that describes your problem then try using a TextBox control. If necessary ensure the actual value (rather than some reference to it) is provided by the underlying data to use.
May 1 '13 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: L Mehl | last post by:
Different users of the app will want or not want to see report footer ( appears as a separate page). I can make the section invisible with a DLookup of a Y or N value from a 'parameters' table ...
2
by: Galina | last post by:
Hello I have a report, which lists records. Each record has money paid field. Money paid can be 0 or not 0. I calculate and print summary of money for a group in the group footer, as well as...
6
by: Mike MacSween | last post by:
I have a report based on: PARAMETERS Forms!frmProductions!ProdID Long; SELECT Sum(qryRoleEvent.Fee) AS SumOfFee, First(qryMusician.LastName) AS LastName, First(qryMusician.FirstName) AS...
2
by: SJM | last post by:
I have a report that displays records of real estate properties. It is possible for each property to appear a number of times for various reasons. Each record however is unique. What I would like...
1
by: jean.ulrich | last post by:
Hi I have a table with 4 fields Customer, Product, Price and Ares As I want to create a report using sorting and grouping I put Customer and I included group header and group footer then i...
13
by: Greg | last post by:
Most suggestions on this topic recommend to use a page footer and make it visible only on the last page. My problem is that the footer is half of the height of a page which means the detail would...
3
by: Lewe22 | last post by:
Upon opening a Report i have created, i need to hide the report footer when 2 text boxes contain the same numeric value. I am hoping something will be possible using the Height property of the...
12
D Giles
by: D Giles | last post by:
Access 2003: A subreport control (sum total calculated textbox located in the subreport report footer) does not show total of all records when referenced as a total in the main report footer - only...
1
by: JeffP | last post by:
Have a textbox in a report footer that sums data using Sum. That text box value is used in a few calculations in the footer. Trouble is, if the report has no data then the box simply shows #error...
4
by: beemomo | last post by:
This is my second post for the same question, hope this time I did explain more clearly about my problem. I need a report that generate the total value of projects from a few foreign currency to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.