Running Sum in a form?

  • Thread starter Thread starter DevourU
  • Start date Start date
D

DevourU

This has to have come up before. How can I have a running sum in a form?
TIA!

-JS
 
I looked and played around a bit with DSum. First I do not have a uniqueID.
This table is created from a make table query. I am also running Access
2003. Ideas?
 
GOT IT! Dang, this was not nice.
runsum: DSum("[stdcost]","partmast","[partno] <= Forms![ABC Inv
Cycle]![RunSum]")

-JS
 
DevourU said:
Cancel taht, it does not work. Can I creat primary keys with a make
table query? TIA
Click to expand...

Please post the SQL of your query. You can't directly set the primary
key with a make-table query, though there are SQL statements you can run
to do it. Are you saying that your table has no field or combination of
fields that can be used as a unique index? Maybe with a bit more
information we can give you better advice.
 
I appreciate the help, but this is kicking my butt. I gotta walk away for a
bit.

-JS
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum If function in textbox 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
run sum in the form 4
Summing in a form! 1
SUM on a Form 2
Summing a complex formula 1
Summing field in Subform 6
Help with VBA and SUM 7

Back
Top