MS access new variable in the same query? 1

[SeeWard]

Hello everyone,
How would I compare a newly created variable field against an existing field within the same query? Is to ask if one can create a variable in the query and reference it in that same query.
TIA

 

[lespaul]

Sure, but you can't reference it by the "name" you gave it:


This will work:

SELECT Sum(SomeField) As Total FROM tblName WHERE SomeOtherField < Sum(SomeField)

but this won't
SELECT Sum(SomeField) As Total FROM tblName WHERE SomeOtherField < Total


Leslie

In times of universal deceit, telling the truth will be a revolutionary act. - George Orwell