Database auto-update of the total quantity

[edsbernardino]

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...

[Killer42]

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.

[edsbernardino]

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?