By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,287 Members | 1,582 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,287 IT Pros & Developers. It's quick & easy.

Form Totals

P: 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
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,768
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

P: 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
Expert Mod 15k+
P: 31,768
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
Expert 100+
P: 1,107
Without more information, the only answer I have is to run the Query Wizard and create a Crosstab Query.
May 29 '15 #5

P: 3
It's a form from a crosstab query. The form does not take the totals.
May 29 '15 #6

Post your reply

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