create a calculated field in a query but not have it shown? i.e.-create a variable?

[crobaseball]

Hi, I've got a query I'm creating that uses several different calculated fields. It would be very helpful for anyone who follows me to have several variables created. basically, rather than have

List: Int(100*([Lines.Price]+[Lines.Freight])*[Lines.DealerAMultiplier]+0.5)/50

I would like to have

List: Int(100*[DLRA]+0.5)/50

where DLRA = [Lines.Price]+[Lines.Freight])*[Lines.DealerAMultiplier]

Thanks

[June7]

Not something I ever thought about. Why don't you test it and find out?

[crobaseball]

I have been. When I try to create DLRA in a field, it disappears when I uncheck the "Shown" box. Can I somehow get to the VBA in a query to create the variable there?

[June7]

Nice to know you attempted and the results.

I just tested and confirmed your results. The field is dropped when query is saved. What is wrong with showing field in query? Just don't show it on form or report.

I do not think VBA will be helpful. Referencing a VBA function in query is still a calculated field.

[crobaseball]

Because I'm importing the data into Excel. And hiding it after pulling it in is a pain in the @$$.

I'm pretty sure this just can't be done. Ah well.

[June7]

You are using the export wizard?

Build query to do the calcs. Use that query as source for another query for the fields to export to Excel.