473,473 Members | 1,955 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to sum a calculated field in Access Report?

24 New Member
I have created a mileage report in access. I created a calculated field called "mileage value" that takes field Mileage x field IRSRate. Each is for a given date field in a table. This works fine in the report.

What I would like to do in the report is now Sum all of the mileage values (shown by date)for a grand total at the end of the report. I can't seem to figure out how to do that since the Mileage Value field is really just a calculated field the the report.

Any advice? Thanks.
May 15 '11 #1
3 27842
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
Its been a while since Ive done this sort of thing so I could be remembering incorrectly:
Assuming your calculated field is shown/calculated in the control called tb_MileValue you should be able to place another textbox in your report footer with control source =Sum(tb_MileValue) or so I think. The other option would be to perform the calculation in your query and then sum the field in the report footer.
May 15 '11 #2
NeoPa
32,556 Recognized Expert Moderator MVP
I can't find anything in Help with which to confirm this, but my understanding is that the Sum() function applies to Fields in the RecordSource, and not to Controls within the form itself (Sorry). It looks like it will need to be presented as a field in the RecordSource if you're to use it that way.

PS. I just thought I'd check, and I managed to confirm the truth of that. Only fields handled by Sum() and other Aggregate functions.
May 16 '11 #3
Daryl Austin
24 New Member
Thanks. I created a calculated field within a query then created a sum of the calculated field from the query within a report. Thank you for the help.
May 16 '11 #4

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

Similar topics

2
by: Derek Erb | last post by:
I have a field in a report which is filled by a function. This is because I want the values displayed in a particular way. The field is filled with: strVal = Format(ValLow, "$#,###") & " / " &...
2
by: Norma | last post by:
I have a table with a UPC#, CasesCompleted, TotalHours, standardGoal (pieces per hour) I am generating a report that groups by UPC and figures out production goals. In the Detail section of each...
9
by: Colin McGuire | last post by:
Hi, I have an report in Microsoft Access and it displays everything in the table. One column called "DECISION" in the table has either 1,2, or 3 in it. On my report it displays 1, 2, or 3. I want...
2
by: hhathome | last post by:
In my report I have a calculated DateDiff Field, I also have a calculated count field. I'm trying to get a total of the DateDiff field and dividing it by the count field and I'm having problems --...
4
by: Apple | last post by:
Can I edit an calculated field in my form if needed. Thank you in advance for your help. Sincerely Apple
1
by: Frankie via AccessMonster.com | last post by:
Hello, I have the following issue: On a report footer based on a query, grouped by (Type being "in" and "out"), with totals by in group footer and report footer, I want to add a calculated...
2
by: John | last post by:
I am using Access 2000. One table in my database has a field called RankName. Values inlcude: Officer, Sergeant, Lieutenant. I need create a report that groups these three RankNames into two...
2
by: john | last post by:
I have a report based on query that has output fields: Category1 Category2 Category3 SumOfAmount The report has a group band on category 1. Within this group I would like to sum the values of...
3
by: kelley.l.turner | last post by:
Hi all, I am very new to MS Access so please bear with me! I have created a simple calculated field in my data entry form, yet when I view my data table or try to generate a report based on...
1
by: MNNovice | last post by:
I am trying to create a report that will keep remaining balance on each grant. But I am struggling with one little problem (for you gurus out there) all morning. Can someone please help? Here is...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.