Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    10

    Arrow Unanswered: Saving data in Queries

    I have created a select query to calculate a %age value from another field:

    Price: [Contract Price]/100*60

    I have then used created a form based on this query. When I run the form, the 'Price' field is automatically updated when I enter the 'Contract Price', however, I now need to save this calculated value into the 'Price' field in the table but can't find any way to do this. Am I using the wrong type of query?

  2. #2
    Join Date
    Apr 2004
    Location
    Bucharest, Romania
    Posts
    16
    you can try to update Price value with an update query on your table
    or to set recordsurce to your table and at the event On Change for [Contract Price]:
    Me.Price.Value =((Me.[Contract Price].Value)/100*60)

  3. #3
    Join Date
    May 2004
    Posts
    10
    That worked very well, 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
  •