Adding Database Cell Values Together!

Home built / N/A
November 4, 2010 at 09:57:46
Specs: Windows Vista Ultimate 64Bit, AMD64 3800+ / 768DDR

I'm creating an application which uses a database to store my finance details. However, i'm unsure how to create a totals readout. I want to add together a bunch of values within various cells and create a total. So, i may have some columns called, mortgage, spends, tax, food....and so on. I want an extra column which gives me a total of what's outgoing. I would really like to know how to reference specific cells in the database, as i'm sure this is what i need to do anyway...or create a query!

Can anyone help?



See More: Adding Database Cell Values Together!

Report •

November 4, 2010 at 14:24:14
What you really need is the General Ledger function of an accounting package.

Report •

November 5, 2010 at 03:49:09
Ok, perhaps i didn't explain my situation that well...rubbish wording on my part!

A different approach:

I'm using VB.NET Express 2010 and have created a table from within which has created an mdf file.

If i drag a label and a button onto a form, how can i have that label show a particular tables column value, depending on which record is selected?

I know i can simply go to the labels properties and set the binding source > text option, and it will do the same thing (without having to press any buttons), but i can't figure out how to write it in code!

I want to be able to pick out certain bits of data from my db table and display it and use it where i like. I did try to view the code generated by VB when doing it via properties, but i can't find it - where can i find this?

Any help greatly appreciated, as this is driving me mad!



Report •

November 5, 2010 at 11:51:33
You are describing is how an accounting package works. They are accounting packages written in many database languages. I am suggesting you look at some for examples, I believe Microsoft Access use to have a sample application in early versions. I have worked in versions using BASIC and xBase and used packages by Real World, Mas90, Peachtree. and others. Basically it is selecting transactions by date and type and summing by groups.

Report •

Related Solutions

Ask Question