Add (Sum) on an update query

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

Guest

I have a database form that is made to work like an spreadsheet. At the end
of a row is a field (total) that I use to update another field in a separate
database (over which I have no control other than being able to odbc my
values to it). This seems to be working fine. However, the complication
comes when there are two rows of calculations that both need to write to that
one field. what happens is that only the latter results get exported over.

is there a way for me to do this? help!!!!!

thanks,
michelle
 
I have a database form that is made to work like an spreadsheet.

Michelle,
That's your first, and biggest, problem. Attempting to make a database work
like a spreadsheet, or vice-versa, is an kind of like an accident looking
for a place to happen.
At the end of a row is a field (total) that I use to update another field
in a separate
database (over which I have no control other than being able to odbc my
values to it). This seems to be working fine. However, the complication
comes when there are two rows of calculations that both need to write to
that
one field. what happens is that only the latter results get exported
over.
Click to expand...

It's hard to say without knowing more, but it seems to me that you would
need to export both of the rows and have the external database sum the
values.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Back
Top