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

Database auto-update of the total quantity

P: 4
Hi everyone, i'm quite new to this forum. My dilemma goes like this..I wanted a program that will have 1 entry at a time and saved in a database. but the database will automatically calculate the total of the quantities i have entered. Everytime a user will transact to the program, the database will update as well as the quantities and total count. I havent decided yet on what backend DB to use..I'm a bit confused. thanks in advance for those who can help me...
May 8 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 5K+
P: 8,434
Hi everyone, i'm quite new to this forum. My dilemma goes like this..I wanted a program that will have 1 entry at a time and saved in a database. but the database will automatically calculate the total of the quantities i have entered. Everytime a user will transact to the program, the database will update as well as the quantities and total count. I havent decided yet on what backend DB to use..I'm a bit confused. thanks in advance for those who can help me...
I'd expect that an automatic update like this would be set up, if possible, in the database itself. If it's supported, that is. But that would depend on what back-end you use.
May 8 '07 #2

P: 4
I'd expect that an automatic update like this would be set up, if possible, in the database itself. If it's supported, that is. But that would depend on what back-end you use.
I intend to use excel as a backend..Now, is it possible that i'll have first a text file where the initial entry will be logged and then it will be transferred to the excel file, now including the subtotal of each column listed in one line?
May 8 '07 #3

Post your reply

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