Trying to build an expression & can't find field error comes up

[sezss]

I'm trying to build an expression to work out the difference between 2 fields AFCost and SfreightValue but everytime i try to save it comes up with could not find field AFCost

Current expression reads =["AFCost"]-["SfreightValue"]

Please help

 

[PHV]

What about this ?
=[AFCost]-[SfreightValue]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sezss]

I'm still getting the error that it does not recognise the field.

 

[PHV]

Have you tried to follow the expression builder ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[KenReay]

Hi

"I'm still getting the error that it does not recognise the field"

What does the error message say exactly

Where are you doing this (ie in a control, in the query builder...etc)

Is there in fact a field called [AFCost]?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK