You are reading a single comment by @cyberyark and its replies.
Click here to read the full conversation.
-
Might not be relevant as I can't speak for access and your table but i would achieve that in an oracle sql script with the use of brackets like
select
this,that, the_other,
thatthing
from
(
select a.this,a.that,a.the_other,
( (a.this-a.that) * the_other) as thatthing
from
mydb.tableA a
where
a.timestamp >= sysdate-1
and
a.timestamp <= sysdate
)
where thatthing = x
cyberyark
you know when you write a nested if statement in access (Wait come back!).
And you think "yeah, i like that". Then you think, "it'd be nice if this column i've just created in the table using this nested if could be used as a thing to order the data by at the end".
so how do you do that then?
how do i put criteria on iif([thisthing]="x",1,0) AS thatthing
so that
FROM [table]
Where thatthing = 1
?
or is it not possible to use (alias?) in this way?