• searching on a calculated value (a2k)

    Author
    Topic
    #408893

    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

    Viewing 1 reply thread
    Author
    Replies
    • #867186

      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.

    • #867187

      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.

    Viewing 1 reply thread
    Reply To: searching on a calculated value (a2k)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: