Results 1 to 4 of 4
  1. #1
    jrock1203 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2015
    Location
    Cincinnati
    Posts
    26

    Calculated field and related table

    Good morning!



    I think I know the answer to this, although I'm hoping I'm wrong!

    I have a form where users can enter dates based on a test sample. There are 5 samples at most taken, and eventually one of those samples will pass the test. Each date also has a check box which records a yes or no in the table - this works just fine.

    What I want to do is then calculate the "days to pass" for this test by writing language that looks at the date that the test passes and does a simple date diff calculation.

    I cannot for the life of me make this work. I can make it display the days to pass on the form, but I need it to record it in the table as well.

    Thoughts?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,522
    Allen has some relevant thoughts/methods here:

    http://allenbrowne.com/casu-14.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    jrock1203 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2015
    Location
    Cincinnati
    Posts
    26
    Quote Originally Posted by pbaldy View Post
    Allen has some relevant thoughts/methods here:

    http://allenbrowne.com/casu-14.html
    pbaldy FTW! Thanks a ton!

    J

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,522
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 9
    Last Post: 02-24-2017, 07:12 AM
  2. Replies: 1
    Last Post: 06-06-2016, 06:05 PM
  3. Updating Field in Table vs. Using Related Table
    By rjgriffin46 in forum Access
    Replies: 2
    Last Post: 05-09-2016, 02:40 PM
  4. Replies: 1
    Last Post: 08-27-2014, 04:16 PM
  5. Replies: 8
    Last Post: 09-08-2013, 12:34 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