Text in a calculated field

[jboyle]

I have a field called length that is inches. The user inputs the length as 24. On my report I want to have it look like 24". I tried the following formula but it doesn't work:
=[Length] & " " "
Needless to say, the " symbol is to identify text and this is causing problems.
Thanks in advance to any help - John

 

[SteveA]

Instead of [Length] & """ try [Length] & '"'. The change is subtle, but it works in queries. It should work in reports as well.

HTH
SteveA

 

[jboyle]

Thanks Steve... Your solution works just fine.