Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    1

    Unanswered: How to subtract two values from two tables

    Helllo everyone
    How are you ??

    I need your help
    i attached a sample file, i want to know how can i make a Remaining hours that will take the teacher_observno from the teacher table and subtract it from the total hours in the subform!!!

    Have a nice day
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by Nokia N93 View Post

    ...how can i make a Remaining hours that will take the teacher_observno from the teacher table and subtract it from the total hours in the subform...
    Isn't this reversed? Shouldn't it be 'take the teacher_observno from the teacher table and subtract the total hours in the subform from that, so that

    Text11 = teacher_observno - Sum([observ_hours])

    If so, put this in the Control Source Property of the Text11 Control:

    Code:
    =DLookUp("[teacher_observno]","teacher","[TID] =" & [TID])-Sum([observ_hours])


    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •