PeterBaileyUk
asked on
SQL invalid column name
I dont know why but I have a column and whatever i call it it says its an invalid name and not sure why. Ive created it called 'CalcPer' and its in the table column list but when i do a select its underlined in red despite showing data. I can do data operations to it
ASKER
so i dropped it and created
i was going to embed the picture but the ee website itself is mucking around in Chrome itself
select prev, change, actualvariance, PercentageDiff, FieldName
from TblCompareEvents
i was going to embed the picture but the ee website itself is mucking around in Chrome itself
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok thank you
My guess is that isn't the column name that's wrong but something you typed before.