how do i use an update querie to display previous value

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

Guest

I am trying to use information from a previous record to show up in my new
record. I read that i should use an Update query but how do i use it..i tried
the HELP from access and it won't give me the answers i need or the
Expression to use value from the previous record...i don't want to Define an
exact amount cause it will still be changing just not as much as other fields.

Ex. If i have 20 orders for Ny, NY 5 th ave, and 30 orders for Japan, and 25
orders for California...i don't want to type in the value to those fields 20,
30 or 25 times if there is an easier way for the new record to fill it in
using information from the previous record...if this is possible please let
me know how...if there is an expression to do this i would like to know what
it is.

Thanks for your help.
 
I am trying to use information from a previous record to show up in my new
record. I read that i should use an Update query but how do i use it..i tried
the HELP from access and it won't give me the answers i need or the
Expression to use value from the previous record...i don't want to Define an
exact amount cause it will still be changing just not as much as other fields.
Click to expand...

An Update query updates the value of fields in existing records. An
Append query creates a new record. It sounds like you might need an
Append query instead, if you need any sort of action query at all -
see below.
Ex. If i have 20 orders for Ny, NY 5 th ave, and 30 orders for Japan, and 25
orders for California...i don't want to type in the value to those fields 20,
30 or 25 times if there is an easier way for the new record to fill it in
using information from the previous record...if this is possible please let
me know how...if there is an expression to do this i would like to know what
it is.
Click to expand...

It sounds to me like your table design may need some work! If you have
a one (<whatever>) to many (<orders>) relationship, it sounds like you
should store a record once and use a Subform. Are these 20 *IDENTICAL*
orders in all fields? or identical in some fields and not others?

Please explain your table structure, and the nature of the information
which constitutes an "order".

John W. Vinson[MVP]
 
This sounds more like a forms problem to me.

You can set the default value of a control on a form to be the last entered
value using some VBA code. So the first question is are you doing your data
entry using a form?
 
Back
Top