Dsum problem- I've made a basic mistake

[swamprat96]

Have a look at the attached test.db. I'm trying to make a running total in the Query- but I'm obvioulsy making a basic mistake. Can someone point me in the right direction?

Cheers

Tony

 

[Galaxiom]

I am amazed the DSum works at all. You are getting the total number of records times the value in the record. I don't understand what it is doing.

A DSum requires the fieldname to be in quotes marks like the table name.
However it won't do a running total.

Search the forum for runing total as it has been covered before.

 

[swamprat96]

I haven't been near Access for about 5 years so go easy. Trying to recall it all I read http://support.microsoft.com/kb/290136 - which uses DSum for a running total. Their example was much more complicated than I need so I was trying to understand how the thing worked.

I have searched the forum- before I posted- and couldn't find anything. However the search engine on this type of forum is always a little difficult so I'll try again

 

[vbaInet]

Have a look at the attached based on your db.

 

[swamprat96]

Ah- totally misunderstood DSum- thanks!. I thought the syntax was too simple- now I get it

Cheers

Tony

 

[vbaInet]

No worries. Glad that helped your understanding of an aggregated function.