Enter Parameter Value (need help)

[alloyd1]

I have a query and one of the fields/headings i have it create is a "cost" total where it does a dlookup from a defaults table.

I then have a "listprice" which is antoher field in the querry of which the data table sits.

I want to take the [listprice] and minus the [cost] without re-creating the dlookup function...

I need this to help with an APR calulction using the RATE function which if i have it do all the dlookups it says I have exceeded the limitiation and will be trumcated. So if i use the name [cost] it works but i have to hit enter because it says "Enter Parameter Value".

Any ideas how to get around this?

Thank you.

 

[ajetrumpet]

I have a query and one of the fields/headings i have it create is a "cost" total where it does a dlookup from a defaults table.

I then have a "listprice" which is antoher field in the querry of which the data table sits.

I want to take the[listprice] and minus the [cost] without re-creating the dlookup function...

If your SQL code is....

SELECT Function([part1], [part2], etc...) as [newfield], yourtable.listprice

then you should be able to use the newfield in an expression for the third field...

SELECT Function([part1], [part2], etc...) as [newfield], yourtable.listprice, ([newfield]-[yourtable.listprice]) as [newfield2]