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 / Queries / November 2007

Tip: Looking for answers? Try searching our database.

DateAdd help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tara - 20 Nov 2007 18:31 GMT
I have a table (tbl125) that holds employees yearly desired contributions to
a medical plan my agency offers.  That desired amount is divided by 26 ( we
are paid every 2 weeks) to come up with the amount that will need to be
deducted from each paycheck in order to reach the goal by then end of the
year.  I have a query in place that does that.  However, now I'd like to take
it one step further and update a field in tbl125 called YTDContributions.  
What I would like to have happen is have the YTDContributions field show how
much an individual has actually contributed up to that point.  Any ideas?

Thanks in advance!
Klatuu - 20 Nov 2007 19:11 GMT
Storing calculated data in tables is not correct.  The correct approach would
be a query that sums the value.

Signature

Dave Hargis, Microsoft Access MVP

> I have a table (tbl125) that holds employees yearly desired contributions to
> a medical plan my agency offers.  That desired amount is divided by 26 ( we
[quoted text clipped - 6 lines]
>
> Thanks in advance!
 
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.