473,320 Members | 1,802 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.

Totaling columns in a report

In my report, I am populating a column with values computed by different means.

Eg

Rows 1 to 8 : column contents are (fieldA + fieldB)
Row 9 : column contents are zero if fieldA = 100,
otherwise (fieldA + fieldC)
Rows 10 to 40 : column contents are 100 if fieldA = 0,
otherwise (fieldA – fieldD)
There are various other computations, up to row 100.

I now need to give a total of my 100 rows in the Page Footer.
The sum function appears to apply only to fields, rather than column contents.
Can anyone advise if there is a way to use a function to sum the contents of my column ?
Many thanks.
Oct 14 '09 #1
2 2304
ChipR
1,287 Expert 1GB
If you can create your column as a calculated field in an underlying query, you can SUM the column(s) on your report.
Oct 14 '09 #2
NeoPa
32,556 Expert Mod 16PB
What are Rows in an Access report other than records. This makes little sense to me. Perhaps you could phrase you question more clearly.
Oct 15 '09 #3

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

Similar topics

1
by: dan | last post by:
I am wondering if anyone can tell me how to add the totals city by city clearing the screen after each, then putting the grand total of all the city's on the final screen. The input file has id,...
0
by: Sal | last post by:
Hi, I have a table in which I performed all of my complex calc's so I can have a simple report to sub total and group. My report works fine except for the footers. I have groupings by city and...
3
by: DeanL | last post by:
Hi all, I'm currently pulling out my already thin hair and need a little help if possible. I have an Access 97 db that is used to store inspection information for different regions. My report...
2
by: Ryker | last post by:
In table A I have a field called Color. I have a color report that groups the colors and prints the total. One section will list and total all the records that have red in the color field, one...
4
by: NormAmst | last post by:
I have a list of CPU processing times and job durations for an entire department at work. There are 3 classifications I am maintaining. CPU time during peak hours , CPU time during non peak hours...
5
by: JRNewKid | last post by:
I have an Access report and in the body of the report there is a calculation: =DateDiff("n",,)/60 This is in a field called dlyElapsedTime. at the end of the report I want to have a total of...
1
by: HERNDON | last post by:
Please help. I am creating a database at work and have run into some issues. One of the reports to be generated has total summarizing at the end for info to be filtered from one or more forms. I...
2
by: sukitmw | last post by:
Hi, I'm trying to sum each column and each row of a datagrid and put the totals of columns at the bottom of each column and totals of row at the last empty column. How do I do this? I found...
2
by: Coxmg | last post by:
I have several related tables. One table lists orders with due dates for SKUs while another table lists components of a SKU (diamonds). A third related table lists diamond IDs and diamond inventory....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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
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: 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: 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: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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

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.