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 / General 2 / August 2007

Tip: Looking for answers? Try searching our database.

formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
StevenThompson - 31 Aug 2007 18:56 GMT
Can someone please tell me how to insert a formula.  I have a training dates
that were completed on 1 jan but in the next column i want to be 15 months
later to whatever date i enter in the 1st colum.  How do i do this?  thank
you!
Rick Brandt - 31 Aug 2007 19:06 GMT
> Can someone please tell me how to insert a formula.  I have a training dates
> that were completed on 1 jan but in the next column i want to be 15 months
> later to whatever date i enter in the 1st colum.  How do i do this?  thank
> you!

In a table, you don't.  Access is a database, not a spreadsheet.  Do the
calculation in a query and use the query instead of the table.

YourNewFieldName: DateAdd("m", 15, FirstFieldName)

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Maurice - 31 Aug 2007 19:18 GMT
Hi Steven,

Try this in your query:

x: DateAdd("m";15;[yourdatefield])

Where x=the name you want to give as a columnheading (replcae with your own)
Where yourdatefield has to be replaced with your own datefield.
p.s. depending on your regional settings the ; might also be a , my guess is
that you should use the comma instead of the ;

hth
Signature

Maurice Ausum

> Can someone please tell me how to insert a formula.  I have a training dates
> that were completed on 1 jan but in the next column i want to be 15 months
> later to whatever date i enter in the 1st colum.  How do i do this?  thank
> you!
KARL DEWEY - 31 Aug 2007 20:30 GMT
Not all training is required to repeat at the same interval.  
So build a table with training courses in two fields --
Course   Interval
Develop intervals based on your lowest common denominator.  If you have
traing at one year, 18 months, and quarterly then use number of months - 12,
18, 3.
If by chance you have some at a lower interval like five weeks then you wil
need everthing in weeks.
To calculate the next training use DateDiff function.

Going further some employees may take a class but not need it as a training
require but you still want to capture the fact they attended but not schedule
them again.  Here you would want another table that has EmpID, Course, Reqd
fields to set criteria for planning.
Signature

KARL DEWEY
Build a little - Test a little

> Can someone please tell me how to insert a formula.  I have a training dates
> that were completed on 1 jan but in the next column i want to be 15 months
> later to whatever date i enter in the 1st colum.  How do i do this?  thank
> you!
 
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



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