Results 1 to 2 of 2
  1. #1
    Lipe1986 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2015
    Posts
    1

    Date function

    Hello how can i make an ms access Table that every user that i add to have one cell that is the start date of school and automaticly to calculate the date of the end of semerster (3 months)and automaticly display the end day of course (6 months)

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Cell is a spreadsheet term.
    You don't store calculated values with database - you calculate when needed via a query.

    Suppose you had a table tblSchoolYear with a field StartDate type date

    You could use a query

    Code:
    Select StartDate
    , DateAdd("m",3,StartDate) as EndOfSemester
    , DateAdd("m",6,StartDate) as EndOfShoolYear
     from tblSchoolYear

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Date with Function After It
    By KurtW in forum Queries
    Replies: 24
    Last Post: 04-20-2015, 05:42 AM
  2. Replies: 2
    Last Post: 06-25-2014, 11:00 AM
  3. Replies: 7
    Last Post: 02-25-2014, 03:11 PM
  4. Date Function
    By joewhitt in forum Queries
    Replies: 7
    Last Post: 07-17-2011, 07:22 PM
  5. Date Function
    By tmcrouse in forum Queries
    Replies: 2
    Last Post: 12-02-2010, 08:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums