Count

[ddrew]

I wonder if someone can help me with a count function. I ahve looked at the help files, but I cant understand it. Basiclly I have a number box on a form, I need to add to gether the numbers from each record to form a total. Simple as that! Thanks!

 

[ScottGem]

Try a DSum

 

[ddrew]

Sorry I'm still none the wiser

 

[ddrew]

No worries I worked out a way with a query to get what I wanted, thanks anyway.

 

[ScottGem]

I wonder if someone can help me with a count function. I ahve looked at the help files, but I cant understand it. Basiclly I have a number box on a form, I need to add to gether the numbers from each record to form a total. Simple as that! Thanks!

=DSUM("[fieldname]","table")

Will "add to gether the numbers from each record to form a total." Isn't that what you asked for? Did you lookup DSUM in Access Help?