MS Access Database with External Data - Re: Copy the result of an automated calculation into a table from

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Copy the result of an automated calculation into a table from

Northstar

2006-04-06, 3:29 am

Makes sense. Thanks

"Jeff Boyce" wrote:

> First, it is rare that you will need to save a value that can be
> (re-)calculated from existing data. And there are some very good reasons
> NOT to do so.
>
> Instead of having to add a field to the table, and do the calculation, and
> save the value, why not just do the calculation in a query? You could use
> that query to "feed" your forms and reports, so you may not need to save the
> calculated value.
>
> --
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
> http://mvp.support.microsoft.com/
>
> Microsoft IT Academy Program Mentor
> http://microsoftitacademy.com/
>
>
> "Northstar" < Northstar@discussion
s.microsoft.com> wrote in message
> news:A23443C7-08DD-44D7-899E- 51B13E5FDCF7@microso
ft.com...
> From
> in
>
>

Sponsored Links