run query with a form command button?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there any way to run an append query via a button on a form? i have a
field in a table (and on my form) that i want to be a running sum of a number
of other fields (also on the form).
i was going to try and make a macro to run the append query that calculates
the sum of the fields, but can't get them all to connect. (there is no macro
called "run append query")
thanks so much!
ashley
 
Ashley said:
is there any way to run an append query via a button on a form? i have a
field in a table (and on my form) that i want to be a running sum of a number
of other fields (also on the form).
i was going to try and make a macro to run the append query that calculates
the sum of the fields, but can't get them all to connect. (there is no macro
called "run append query")
thanks so much!
ashley
Click to expand...


A running sum of fields saved in a table? BAD design. Calculate at
runtime. what happens if you delete a record?

DoCmd.OpenQuery "QueryName"
 
Back
Top