Create a SQL on a calculated filed

  • Thread starter Thread starter Adrian G Vasile (BDI)
  • Start date Start date
A

Adrian G Vasile (BDI)

I have a querry that contains few calculated fileds. Then ii would
like to add a row that would display one of my records if calculated
fields meet a certain condition. It doesn't work using the SQL view in
Access.
Any help would be appreciated.
Thank you,
Adrian
 
Adrian said:
I have a querry that contains few calculated fileds. Then ii would
like to add a row that would display one of my records if calculated
fields meet a certain condition. It doesn't work using the SQL view in
Access.
Click to expand...


The calculation expression needs to be repeated in the WHERE
clause. For example:

SELECT field1, field2, field1 + field2 As total
FROM table
WHERE field1 + field2 > 3
 
Back
Top