[AccessD] AC2010-a pioneer with more arrows in the back...

>
> Format$(Product_PK,"0000" & Left$([Product_Descr],4)
>
> It threw the helpful error:
>
> "The expression Format$(Product_PK,"0000" & Left$([Product_Descr],4) 
> cannot be used in a
> calculated column"
>
> A bit of testing reveals that you can't use Format/Format$ in a calculated 
> field.
>

========In all fairness, formatting a value isn't the same as a calculated 
column -- gentlemen, light your arrows!!!!! :) It's Friday, it's after 5:00 
pm and well...

Susan H.