calculated field in query? other ideas?

[julessantana]

I need to multiply a column in a query by another column in a query. One is a value, and one is currency.



One table has a list of commodities and costs per commodity.

Another table has a list of all of the open purchase order lines, including the type of commodity, and the remaining amount to be received. This table does not have cost per commodity, because dlookup doesn't work in the actual table.

I need to multiply the remaining amount of a commodity by the cost of the commodity.

I created a query to list the commodity, work order number, remaining quantity, and cost per commodity.

How can I get a query/report that will show how much is remaining per line of the PO?

End result that I need is a report that will show, per work order, the total amount of outstanding commodities. This is used for cost projection for the work order.

Any ideas?

[ranman256]

Dont use dlookup in a query.

To calculate in a query, just put the fields and the operator: TotalDue:[Cost] * [Qty]
AmtRemain: [Inventory]-[Qty]

[julessantana]

I don't want to use a dlookup in a query. I just want to multiply one field in the query by another field in the query. Sorry, I must not have explained that very well.

Thank you! I figured it out. The expression is just typed into the "field"