Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Cedar Falls, Iowa, USA
    Thanked 0 Times in 0 Posts

    searching on a calculated value (a2k)

    We have situations where we receive checks in payment and it's a challenge to chase down what it's in payment of. I have a form that provides parameters to a query for looking up the record by order number, person ordering, and organization associated with person ordering. I'd also like to took it up by order total, but order total is a calculated value in a form object.

    What's the best approach here? Do I need to save the calculated value using the form object's AfterUpdate to the underlying orders table?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: searching on a calculated value (a2k)

    If possible, avoid storing calculated values in a table. Can you calculate the value in the query that acts as record source of the form? You could then treat it like the other fields for searching purposes.

Posting Permissions

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