Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    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?

    E

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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
  •