Recent content by tennisbuck

Does anybody know how to create this function?

Hi Board, Really stumped and was hoping for some help. Most likely this has to be done in VBA and this is not my strong point in data analysis. I basically have a table in this format: Sold To Marketing Name Total Sales Dollars 10009 Mufflers 100,000 My question is how would I create...

Which function in access return the the last value in a string. Period 1 Period 2 Period 3 10 20 30 I need the function to return 30. The reason behind this I have different periods for categories and my formula I'm using needs the ending value.