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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Spade (Spade_at_discussions.microsoft.com)
Date: 03/16/05 

Date: Tue, 15 Mar 2005 17:33:03 -0800

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.
> >>
> >>
> >>
>
>
>

Quantcast