Running Sum in a form?

[DevourU]

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

-JS

 

[DevourU]

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?

 

[Dirk Goldgar]

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

Did you try searching Google Groups?

http://groups.google.com/groups?as_...81&as_maxd=1&as_maxm=11&as_maxy=2005&safe=off

 

[DevourU]

GOT IT! Dang, this was not nice.
runsum: DSum("[stdcost]","partmast","[partno] <= Forms![ABC Inv
Cycle]![RunSum]")

-JS

 

[DevourU]

Cancel taht, it does not work. Can I creat primary keys with a make table
query? TIA

-JS

GOT IT! Dang, this was not nice.
runsum: DSum("[stdcost]","partmast","[partno] <= Forms![ABC Inv
Cycle]![RunSum]")

-JS

Did you try searching Google Groups?

http://groups.google.com/groups?as_...81&as_maxd=1&as_maxm=11&as_maxy=2005&safe=off

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Cancel taht, it does not work. Can I creat primary keys with a make
table query? TIA

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.

 

[DevourU]

I appreciate the help, but this is kicking my butt. I gotta walk away for a
bit.

-JS