UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Adding The Same Field In A Report, Access 2016    
 
   
jotoya
post Jun 12 2019, 06:51 PM
Post#1



Posts: 128
Joined: 17-May 16



Hi -

This is probably a pretty dumb question but I haven't ran into this problem before. I've always heard and read that totals should always be done via a query or report and not directly in a table.

I have a report in which I have a textbox that simply adds 7 columns (across, left to right) to provide me a total for that row as such:

=[Column1]+[Column2]+[Column3]+[Column4]+[Column5]+[Column6]+[Column7]

So if my table has 5 rows, each row will have its own total. This works well and the textbox will provide me the total for each record as seen in the 'Detail' section of the report.

Here's where I'm getting all goofed up: Since I don't have a 'total' column in my table, how can I add these records' already obtained row totals to produce a grand total, since the textbox, as you know, is displayed just once in the 'Detail' section? iconfused.gif

Thank you so very, very much.
Go to the top of the page
 
MadPiet
post Jun 12 2019, 06:56 PM
Post#2



Posts: 3,120
Joined: 27-February 09



Maybe put SUM([field1]) + SUM([field2])…. in the page or report footer?
Go to the top of the page
 
jotoya
post Jun 12 2019, 07:16 PM
Post#3



Posts: 128
Joined: 17-May 16



Thank you MadPiet!! Worked perfectly and I learned something new. Much, much appreciate it! hat_tip.gif
uarulez2.gif
Go to the top of the page
 
MadPiet
post Jun 12 2019, 07:29 PM
Post#4



Posts: 3,120
Joined: 27-February 09



You're welcome! Anytime.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    15th June 2019 - 10:31 PM