Trying to create query for commision on products, nothing coming up when ran, what am i doing wrong?

New Contributor
1 Reply


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.