Re: copy value from field to another in same table, different reco

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 03/16/05 

Date: Tue, 15 Mar 2005 21:43:01 -0500

? the reason for my questions is to identify how to trigger the update and
how to do the update...it'll require either an update query or some
programming to "identify" the "last record" and such. This is not a trivial
thing to do if you want to automate it, especially as it's not a regular
feature for databases to do.

If you can provide the info, we can help you identify the solution. 

-- 
        Ken Snell
<MS ACCESS MVP>
"Spade" <Spade@discussions.microsoft.com> wrote in message 
news:BC096BC2-15EE-49E6-8402-8AFD9FBFEB7B@microsoft.com...
>a form.  but thanks anyway.  I've been humiliated enough today.  I'll find
> another way or skip it.
>
> "Ken Snell [MVP]" wrote:
>
>> Yes, I understand. When will this "calculation and storage" occur? It 
>> needs
>> to be triggered by some action -- clicking a button on a form, for 
>> example.
>>
>> Note that such calculations usually are not stored in a table, but there 
>> are
>> exceptions for doing so (depending upon the data design and purpose).
>>
>> What is the structure of your table where these data are stored?
>> -- 
>>
>>         Ken Snell
>> <MS ACCESS MVP>
>>
>>
>>
>> "Spade" <Spade@discussions.microsoft.com> wrote in message
>> news:EF9B971F-7626-4F33-A663-69312C06A69C@microsoft.com...
>> > don't have to store it - it can be calculated...  it's for a "cash
>> > register"
>> > situation.  I want to take the closing amount from one day, which is
>> > calculated with [actual]-[withdrawal] and make that closing amount the
>> > opening amount displayed on the register form screen for the next day.
>> >
>> > currently displayed on a form.  opening, actual count and withdrawal 
>> > are
>> > saved in a table.  closed amount is calculated.
>> >
>> > having problems with how to display a field value from a previous 
>> > record
>> > while another record is current.  make sense?
>> >
>> > "Ken Snell [MVP]" wrote:
>> >
>> >> When is this supposed to occur? Macro will not run from a table; must 
>> >> run
>> >> from a form or other similar object.
>> >>
>> >> Why do you want to store what appears to be redundant data?
>> >>
>> >> -- 
>> >>
>> >>         Ken Snell
>> >> <MS ACCESS MVP>
>> >>
>> >> "Spade" <Spade@discussions.microsoft.com> wrote in message
>> >> news:43D75110-C091-41EA-A29D-81371AEAF25C@microsoft.com...
>> >> >I need a macro to automatically copy the value of a field from one
>> >> >record
>> >> > into the value of another field in the next record...  so, for 
>> >> > example,
>> >> > [closeamount] needs to be copied or forwarded into [openamount] for 
>> >> > the
>> >> > next
>> >> > day.
>> >>
>> >>
>> >>
>>
>>
>>