Recent content by samMSaccess31

Lol, thank you for that...believe it or not I had already tried that.... From looking on google, I sorta found out that I am supposed to use the DSUM function. As it is quite complex and I am a bit of an access rookie, I couldn't get it to work. Thus the reason I posted it on this forum with...

I'm sorry, I don't think that helps me with what I'm looking for... I'm trying to create a 4th column that formulates a CUMULATIVE SUM of the individual profits listed in the 3rd column

I've attached the current SQL: SELECT [Cash_Raw Data].[Session ID], [Cash_Raw Data].[Start Date], [Cash_Raw Data].Profit FROM [Cash_Raw Data]; I've struggled with this for a little while so if anybody could give me a hand with it that would be great!

Hi everyone, So I'm trying to create a running total, to be able to graph a cumulative total. After looking around, I think I've figured out that I need to use a DSUM formula. Can anybody help me out? I basically want to get a cumulative sum of profit in the 4th column. Image attached, thanks!

No Bob, that isn't working for me. Does anybody else have any ideas?

Hello everyone, So I am trying to use a query to replace quotation marks in EVERY column in a table. Now, I have two problems here... 1.) I think I am looking at replacing each column individually. For example, for a table with 4 columns, I am looking at... Replace([Table]![Column1]...