Build Expression in Query

[rwpspackett]

I can't seem to find this topic anywhere.

I have a company that sells me 3 products for resale on consignment.

I currently have 3 queries each with a field that includes a build expression.

The individual query has an individual find criteria (product X, Y or Z)

The Build Expression in each query says Pay Company for Product X: [product sold]*price



Now I know that I can build the query to gather all 3 products BUT can I then have a build expression that says take product X*price, product Y*price and product Z * price?

I then want to be able to create a report that takes the data and allows me to produce a clear report showing units sold per product and amount I need to pay the company.

I keep thinking this must be possible and I am simply having a brain cramp.

Thanks in advance.

[Perceptus]

My brain has cramped as well. I can't brain today I has the dumb.

Your issue should be possible. Have you tried creating a new Query to do this?