Link to home
Create AccountLog in
Avatar of mlagrange
mlagrangeFlag for United States of America

asked on

A calculated column cannot be saved without a valid expression in the Expression property

I just tried to run a MakeTable query that uses a table that has a calculated field, and got this error. Where is this "Expression property"?

The calc field works fine in the Select query...

Thanks
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
To be fair, I know that sometime it is needed to Store calculated data.

This is why it is sometimes helpful if you state the need for doing this...

;-)

JeffCoachman
Avatar of mlagrange

ASKER

"the anti-calculated field chorus" - that's funny!
ok, thanks - that's what I've always done in the past (query that does all the calc's)
I was just hoping that M$ had actually provided something useful, but I should have known better. SQL Server has had "Computed Columns" since, what? version 2000?