Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I currently import a bank statement into an Access 2007 table and then use a lookup within the table to categorise each transaction. I then use a report to group the transactions into category types.

However, some of the bank account entries may need to be split further to accurately reflect the breakdown of the transaction into its appropriate categories. For example, a payment to Amazon may be made up of CDs, Books and Software.

I would like to be able to categorise each record into its component parts similar to the way that Microsoft Money splits a transaction – see the attached Microsoft Money screen grab showing my Amazon example split into its 3 component categories.

enter image description here

My database essentially consists of a Bank Account (Import) Table and a Categories Table (containing just a list of categories). I then go though the Bank Account (Import) Table and categorise each entry manually using a lookup:

Import Table

Date.......Payer/payee...CR/DR....Amount......Category

19/4/11...Amazon..........DR..........100............(Lookup)

I understand that the use of lookups within tables is frowned upon.

I should therefore appreciate if someone could steer me in the direction of how best to categorise/split such transactions using (i) tables/queries and/or (ii) programmatically.

Or, is this just a step too far for someone with limited Access knowledge?

Thank you

Grahame

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.