473,405 Members | 2,272 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,405 software developers and data experts.

Form Totals

3
Is there a way to automate multiple column totals in a form (variable no. of columns) not using a split form,(ie Tabular format)
May 27 '15 #1
5 1325
NeoPa
32,556 Expert Mod 16PB
Your question is very light, ironically enough. Too little detail to work with easily.

If I guess correctly though, you could add a matching control in the Header section of the form for each column you want summed in the Detail section.
May 28 '15 #2
Lighty
3
Hi. Thanks for your reply. Lets say the columns are the last 14 days with 20 rows of values. Need a total value by date for each day.
May 28 '15 #3
NeoPa
32,556 Expert Mod 16PB
Lighty:
Lets say the columns are the last 14 days with 20 rows of values
I'm not sure what that's supposed to tell me, but I see nothing to indicate my earlier advice is off the mark any.

Let us know how you get on with that.
May 29 '15 #4
jforbes
1,107 Expert 1GB
Without more information, the only answer I have is to run the Query Wizard and create a Crosstab Query.
May 29 '15 #5
Lighty
3
It's a form from a crosstab query. The form does not take the totals.
May 29 '15 #6

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

Similar topics

3
by: John Baker | last post by:
HI again: I have a form with totals on it, and I am changing the contents of the data base the totals are derived from. Specifically, I am deleting the contents of one table and adding it to...
1
by: Colin Basterfield | last post by:
Hi, I have a web form which takes daily sales totals, both counts and monetary value and is done on a weekly basis, so on a Monday morning the User would enter these totals. Each total has a...
2
by: BradC | last post by:
I have a long VB.NET form with a scrollbar (autoscroll=true, not an actual scrollbar control). In response to one particular buttonclick, I need to scroll down to a particular point on the form,...
3
by: Mike the Canadian | last post by:
Given the code below how can I get the totals to update when the form loads not just when a cell is changed? I tried a call to updateColumn(el) in initTable but this gives a "cell has no value"...
2
by: BerkshireGuy | last post by:
I have the following code: Dim strSQL As String Dim DB As DAO.Database Dim RS As DAO.Recordset Dim intNumOfPaid, intNumOfHypoed, intNumOfNotTaken, intNumOfDeclined, intNumOfWasted,...
2
by: Ron | last post by:
Hi All, I've got a main form (frmMain) with 5 subforms on it. All subforms are linked to different hidden controls on frmMain. The purpose of this form is to record payments by 'source'...
8
by: elias.farah | last post by:
Hello Everyone, I'm having some very weird behavior on a couple of Access forms. (Not all forms, just some of them). The forms have been working for years, under Access XP/2003 etc, and last...
3
by: ebasshead | last post by:
Hi Everyone, I'm having problems with putting a result from a totals query in a form which is based on aother query. If I add the totals query to the form query, I'm not able to add or delete...
12
Brilstern
by: Brilstern | last post by:
I am currently creating a database that will keep track of a supply shops instruments, inventory, and mic. gear. In the home form of this database (frmHome) I have created a tabbed switchboard more...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

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.