hey guys, i need to know if i can do something like this:
i want to in my query, create a new calculated field. this field, is calculated by taking the "quantity" field in my table, multiplied by the "status" field in my table. but the problem is, some of the entries in my status field have a...