Results 1 to 5 of 5
  1. #1
    mikichi is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2013
    Posts
    45

    question|dates calculating

    hi,
    i need to know for how long my student is learning at school.
    in Excel i write in one cell the enter date and next cell the end date, for each student can have a several time periods.


    my formula in Excel was like this:
    =(A1-A2+A3-A4+A5-Now())/365.25
    I.E: A1,A3,A5 - that enter dates, and A2,A4 its end dates - so my student in example start learn in A1 and end to learn in A2 and back to learn in A3 until A4 and learn from A5 untill now.
    how i do this in access??
    thank you,
    miki

  2. #2
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614

  3. #3
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    That part is easy enough, but those dates A1-A5 already need to exist in the database somewhere. In order to get a reasonable answer of how to pull the information out of the database, we would need to know how those A1-A5 dates are stored in the database.

  4. #4
    mikichi is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2013
    Posts
    45
    the problem is that i dont know how much periods i have, maybe i need to connect to each student one to many relationShip?

  5. #5
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    In a typical student-class database, each class has a particular "semester" or "quarter" that it is associated with. If this is the case, then using an aggregate query to count the number of semesters for each student should be the easy way to get what you need.

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

Similar Threads

  1. Calculating dates
    By sivega in forum Queries
    Replies: 7
    Last Post: 06-14-2013, 08:18 PM
  2. Replies: 4
    Last Post: 09-06-2011, 02:20 PM
  3. Calculating Dates
    By TC0126 in forum Queries
    Replies: 1
    Last Post: 02-23-2010, 08:13 PM
  4. Calculating Dates
    By AJ0424 in forum Programming
    Replies: 1
    Last Post: 07-14-2009, 08:29 AM
  5. calculating due dates in access
    By trixxnixon in forum Forms
    Replies: 0
    Last Post: 09-28-2008, 12:35 PM

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