Results 1 to 4 of 4
  1. #1
    BrittKnee is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2020
    Posts
    17

    Exclamation Calculated Field Not Updating Table


    Hi Everyone! I am building a database to track client invoices and payments. I have created 2 expressions within my query to calculate an invoice number (Invoice_ID + 1000) and to calculate payment date (Statement Date + 90). The calculations work in the quest and populate the forms correctly, but they do not update my main Invoice_tbl. I know that calculated fields typically should not update the tbl, but in this case I need to keep track of Invoice # and Payment Dates. Your help is appreciated!

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Not sure what to suggest re the invoice number - perhaps in form current event, make TheField = ID + 1000 as I'd say it's possibly a necessary value in a table but I don't see a need to store a date calculation. If this is for a printed invoice, the report control would be the TheDateYouNeed + 90, and that's what gets printed. If it's for display in a form too, the form field should be TheDateYouNeed + 90 (or use DateAdd function for either). Storing the date doesn't seem necessary in this case and it's usually ill advised anyway.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the form SAVE button or in each AFTERUPDATE event, assign the fields:

    txtboxInvNum = [Invoice_ID] + 1000

    txtboxPayDate = Dateadd("d",90,[Statement Date]) 'using field
    or
    txtboxPayDate = Dateadd("d",90,txtStatemtDate) 'using text box




  4. #4
    BrittKnee is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2020
    Posts
    17
    Thanks a ton!

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

Similar Threads

  1. Updating sum calculated field
    By bid19123 in forum Forms
    Replies: 1
    Last Post: 11-10-2017, 06:55 AM
  2. Calculated field in Combobox Not Updating
    By LemonRawr in forum Access
    Replies: 1
    Last Post: 02-10-2017, 02:17 PM
  3. Replies: 1
    Last Post: 04-21-2013, 03:20 PM
  4. Replies: 1
    Last Post: 03-27-2012, 05:25 PM
  5. Replies: 4
    Last Post: 03-05-2010, 09:56 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