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

To find total from generic column values in subform and displaying it in main form

P: 14
Hi guys, I will be quick this time... Just want to know how we can calculate generic values in the same column. I am using invoice form with a services subform . I have a column of 'total' in subform and I want to add all values of that column to get the total cost on main invoice form. The 'total' column contains service cost of different clients. Some clients have 1 service i.e 1 total which is the total cost but most clients have more then 1 services and for that I have to add all values in same column and save it some where else. Really appreciate your support. Thanking you in advance

Hope you all have a great weekend (rain free :P) Take care
Jul 20 '07 #1
Share this Question
Share on Google+
4 Replies


P: 14
Is it possible in Access?
Jul 23 '07 #2

P: 65
Bit more information would be handy...
Jul 23 '07 #3

P: 14
:) ok this time its not complex like me. If I have to add all values in the same column of a subform what do I have to do?
Jul 23 '07 #4

P: 65
Wanted to delete this post but can't get it to. :s

Calculate de total value for each at a time, then display it in a subform. The values are coming from a recordset or something anyway, no? So you could even calculate them with a do...loop or so.

You could use another table to temporarly store your totals before displaying them.
Jul 23 '07 #5

Post your reply

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