running balance / subtotal (1 Viewer)

[SamDeMan]

Hi

I haven't been on for a while. so hello everybody.

I am trying to keep a subtotal in a table. there is an index (actually its formatted text, but its a number and i can converted i.e. cdbl()). I was thinking that i should create one query with dmax in one column and and then use another one to show the value plus the previous value.

can anybody help me out please?

thanks,

Sam

 

[SamDeMan]

oooops, i found an article on MSDN. http://support.microsoft.com/kb/290136

thanks,

Sam

 

[neileg]

Running totals are a standard feature of reports. Is there a reason why it has to be in your table?

 

[SamDeMan]

Running totals are a standard feature of reports. Is there a reason why it has to be in your table?

subtotals that you are talking about are after a grouping. but each entry i don't think that it would work. i think its pretty simple in a query, dsum()

i guess your method can work, it just may be so efficient.

sam

 

[Rabbie]

I would not store a calculated value in a table. Use a query instead so you avoid problems if one of the values changes later on.

 

[SamDeMan]

just realized, there was a typo in my question, "I am trying to keep a subtotal in a table" is incorrect. i meant to write "I am trying to get a subtotal from a table" sorry for that confusion.

 

[neileg]

subtotals that you are talking about are after a grouping. but each entry i don't think that it would work. i think its pretty simple in a query, dsum()

i guess your method can work, it just may be so efficient.

sam

No, I mean running sums. Look this up in Access help.