Results 1 to 3 of 3
  1. #1
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155

    Control Value

    My problem is that why doesn't my calculated value (in the red control) remain stable as long as the corresponding record is in focus? It remains stable only for the first record. When we move to the subsequent records the calculated value becomes visible and immediately vanishes. I don't want it to vanish. It should remain visible as long as the corresponding record is in focus.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    rec 3 has a record in both tables, so it adds fine,
    rec 4 only has Rcvd, but nothing for Issued, its null, and in math: [anything] + null = null.

    change the calc to : NZ(Rcvd)-NZ(issued)

    it converts Null To Zero.

  3. #3
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155
    Quote Originally Posted by ranman256 View Post
    rec 3 has a record in both tables, so it adds fine,
    rec 4 only has Rcvd, but nothing for Issued, its null, and in math: [anything] + null = null.

    change the calc to : NZ(Rcvd)-NZ(issued)

    it converts Null To Zero.

    Thanks A Lot!! GOD BLESS YOU!!!!!

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

Similar Threads

  1. Replies: 6
    Last Post: 06-04-2018, 06:46 AM
  2. Replies: 7
    Last Post: 03-09-2018, 11:11 PM
  3. Replies: 3
    Last Post: 11-30-2016, 07:18 PM
  4. Replies: 4
    Last Post: 02-18-2016, 12:06 PM
  5. Replies: 8
    Last Post: 06-19-2015, 02:19 AM

Tags for this Thread

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