Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Unanswered: Adding +[Number] to filed

    Dear All ,

    I managed to create a button to add a specific number to a specific Cell.
    i need to make this Update to be done to all cells until EOF.

    eg..(Attached)
    i want to add 1.25 to the field (Initial Annual Leave) till EOF (to all users)

    thank you
    Attached Thumbnails Attached Thumbnails Access.jpg  

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Questions:

    • By 'adding' do you want to actually add an amount to the current value of the Initial Annual Leave field?
    • Is the amount to add always 1.25?

    or


    • Is the amount to add dependent on the second Textbox as per your image? If so, we need of the name of the Textbox.

    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

  3. #3
    Join Date
    Aug 2011
    Posts
    2
    Hi ,
    yes , the number 1.25 may varry from person to another , it is located in the table.

    i managed to create an update querry but it only works for one time , untill any number of those two changes.

    any idea

    thank you

Posting Permissions

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