Apr 21 2021 06:45 PM
It looks like you are trying to use a calculated value as a criteria in the query. It's in the same row as the "DVD" criteria.
That means your query says, "Return records where the Product is DVD and the Commission is equal to the Price * .4"
If you have records that already meet both criteria, then this query would return those records.
However, if your intention is to CALCULATE a commission for DVD;s, that's going to be a different query.