Hi
I currently downolad my bank statement via excel and add a code number to each entry in order for me to see where I am spending most momey
IE
Code...........Shop.........Date...........Amount
1................Amazon.....1/1/18........£100
2................McDonalds..1/1/2018....£9.99
1................Ebay...........1/1/18.......£54.00
So I would have code 1 as electrical items and code 2 as eating out etc
I currently have to manually add each code which is not time efficient especially when I may have visited McDonalds 15 times in the month etc
So, using access I guess I need a master table with
Code.......Shop
1............Amazon
2...........McDonalds
and then something like
if the first item on my Statement is Amazon then put code 1 in my Statement Table if not go on until the shop in my Master table matches the entry in my statement
once this is done it needs to look at the second item on my statement etc
Any help would be great
I currently downolad my bank statement via excel and add a code number to each entry in order for me to see where I am spending most momey
IE
Code...........Shop.........Date...........Amount
1................Amazon.....1/1/18........£100
2................McDonalds..1/1/2018....£9.99
1................Ebay...........1/1/18.......£54.00
So I would have code 1 as electrical items and code 2 as eating out etc
I currently have to manually add each code which is not time efficient especially when I may have visited McDonalds 15 times in the month etc
So, using access I guess I need a master table with
Code.......Shop
1............Amazon
2...........McDonalds
and then something like
if the first item on my Statement is Amazon then put code 1 in my Statement Table if not go on until the shop in my Master table matches the entry in my statement
once this is done it needs to look at the second item on my statement etc
Any help would be great