473,320 Members | 2,006 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 total problem

I have what I hope is a simple question for some of you. I have two
fields. Quantity and Price. I enter a text box named SubTotal in the
detail of the report and set the control source to
=[Quantity]*[Price]. This works fine and I have all the correct
values in the detail of the report. Now at the bottom of my report I
want a total. I insert a text box in the report footer named Total
and set the control source to =sum([SubTotal]). This does not work.
I get an "enter parameter" dialog box for SubTotal when the report
runs.

Any help?

Thanks

Mar 27 '07 #1
2 2081
On 27 Mar 2007 05:53:31 -0700, "bobw2961" <bo******@hotmail.com>
wrote:

=Sum([Quantity]*[Price])

-Tom.

>I have what I hope is a simple question for some of you. I have two
fields. Quantity and Price. I enter a text box named SubTotal in the
detail of the report and set the control source to
=[Quantity]*[Price]. This works fine and I have all the correct
values in the detail of the report. Now at the bottom of my report I
want a total. I insert a text box in the report footer named Total
and set the control source to =sum([SubTotal]). This does not work.
I get an "enter parameter" dialog box for SubTotal when the report
runs.

Any help?

Thanks
Mar 27 '07 #2
On 27 Mar 2007 05:53:31 -0700, bobw2961 wrote:
I have what I hope is a simple question for some of you. I have two
fields. Quantity and Price. I enter a text box named SubTotal in the
detail of the report and set the control source to
=[Quantity]*[Price]. This works fine and I have all the correct
values in the detail of the report. Now at the bottom of my report I
want a total. I insert a text box in the report footer named Total
and set the control source to =sum([SubTotal]). This does not work.
I get an "enter parameter" dialog box for SubTotal when the report
runs.

Any help?

Thanks
By 'at the bottom of the report' I'll guess you mean the Page Footer,
not the Report Footer.

See Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Mar 27 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Bill Dika | last post by:
Hi I am trying to calculate a running total of a calculated textbox (tbAtStandard) in GroupFooter1 for placement in a textbox (tbTotalAtStandard) on my report in Groupfooter0. The problem...
1
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to...
2
by: Michael Keene | last post by:
I'm pretty much a beginner with Access but do have some experience but I'm stuck on this problem. Any suggestions would be appreciated. I have a very simple database that tracks the number of...
7
by: Hank | last post by:
I have a report-summing problem using Access 2000. When a section runs over the end of the page, sometimes a detail gets picked up twice. Example: Customer Header XYZ Company Detail Section...
0
by: galkas | last post by:
Hello I have got a report, which can run on 3 groups of data: College Faculty School Faculty contains schools. College contains faculties. The report can be run for college, then it includes...
1
by: prabhukalyan | last post by:
Hi all, I am not so good in queries. here is my problem 2 tables to store the received items (fabric)-- inwardmaster, inwarddetails and after some processing (Dyeing) the items were...
7
by: Sunil Korah | last post by:
Hi, I haven't used access reports much. I have a problem in getting the total of a group. I have 3 fields, ProgName (Program name), Pname (Participant's name) and PCategory (Participant...
9
by: Zaher Rabah | last post by:
Hi, Explain: I have a report for reciept list , it contain 3 sub report. 1st for cash and it contain sub total 1 2nd for check and contain sub total 2 3rd for Credit card and contain sub...
4
by: lorirobn | last post by:
Hi, I have a report displaying items that are missing from a room. I created 2 queries, the first getting the items IN the room, and the second being an "unmatched" query that references 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...
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
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
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...
0
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.