Posted on 2014-01-29
I don't know a lot about Excel databases and I don't have Access but can a database be set up in Excel that I can keep a running balance. I work at children's home and the children have spending and savings that are all kept in one account at the bank but I keep balance on each child for there spending and savings. Currently it has been set up in excel files, one child for each file. I think we could maybe streamline with a database but not too sure about adding and subtracting from the balances. If it would work it would need to easily add amounts and subtract amount from the two balances from a form.. If it will work I will attempt to setup but don't want to spend a lot of time if it will not work. Any suggestions would be greatly appreciated.