Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / November 2004

Tip: Looking for answers? Try searching our database.

how to sum access page fields and store total in table?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim Wyse - 29 Oct 2004 11:22 GMT
I need to sum several fields on a data access page, and save the calculated
value, displayed in another field, back to the Access table. I can do the
summing, and show the total, but I can't get the Data page to save the total
back to the table for me.
Someone must know what I'm doing wrong?!
Rick B - 29 Oct 2004 18:14 GMT
Jim:

Good database design standards would dictate that you not store a calculated
value in the table.  This is redundant.  When you need the value, just
calculate it.

There are exceptions to this.  If youhave a variable number (exchange rate,
price paid for a stock, etc.) then you may have a valid reason to save the
figure.

If so, post back and someone can give you further direction.

In general though, this would not be the way to go.

Rick B

> I need to sum several fields on a data access page, and save the calculated
> value, displayed in another field, back to the Access table. I can do the
> summing, and show the total, but I can't get the Data page to save the total
> back to the table for me.
> Someone must know what I'm doing wrong?!
Jim Wyse - 01 Nov 2004 11:08 GMT
Many thanks, Rick, that has put me straight!
As you say, it's just as easy to calculate the value whenever it is needed.
Why didn't I think of that before!
Cheers,
Jim

> Jim:
>
[quoted text clipped - 19 lines]
> > back to the table for me.
> > Someone must know what I'm doing wrong?!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.