Announcement

Collapse
No announcement yet.

Unwanted table update

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Something like:

    Code:
    SELECT
    	tblsalesperson.name
    FROM
    	tblsalesperson
    WHERE
    	active = 1
    	OR
            (active = 0 AND '{orderdate}' BETWEEN act_date AND deact_date)
    ORDER BY
    	name ASC

    {orderdate} is the order date from the form's current sales order

    Comment

    Working...
    X