Use of field Alias in calculated field of same query

[CRinne]

I have a query that sums up sales numbers in one column from and another column which is forecasted sales numbers. I would like to use the field alias in another field to simply find the difference between the two. I tried using the alias names, but of course Access didn't understand it, so is it possible??? If so, what is the syntax to use for the calculation????

[ItsMe]

You have to run the calc in the first column before the second calc can be done. Aggregate is not possible running a single query. A quick and easy way may be to create a second query object that runs the first calc/alias and then join the first query object in a second query using the query builder.

[CRinne]

You have to run the calc in the first column before the second calc can be done. Aggregate is not possible running a single query. A quick and easy way may be to create a second query object that runs the first calc/alias and then join the first query object in a second query using the query builder.

That explains the problem very well. Great suggestion, I will try that approach. Thanks for the quick feedback!!!

[CRinne]

I tried your suggestion and worked like a charm. Thanks again for the help!

[ItsMe]

It may not be the most eloquent solution but it is something that you managed on your own.