By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

removing last letter in data for a report

P: n/a
HI
I have a ata feild with a stand code EG A23H, there are three letters H, W & C
but i do not wish them to be printed in the reports. How can i remove this
letter during a query thatr creates a report so that it is not on the final
printout
thanks in advance
Karl
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 18 Feb 2004 17:41:22 GMT, Karlwasley wrote:
HI
I have a ata feild with a stand code EG A23H, there are three letters H, W & C
but i do not wish them to be printed in the reports. How can i remove this
letter during a query thatr creates a report so that it is not on the final
printout
thanks in advance
Karl

In the query?
NewColumn:Left([FieldName],Len([FieldName])-1)
Include this NewColumn field in the report.

You can also do it in the report itself.
Just use the above expression in an unbound control's control source:
=Left([FieldName],Len([FieldName])-1)
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

P: n/a
In a query ...

SELECT Left$([FieldName], Len([FieldName])-1) AS SomeAlias FROM SomeTable

Or in the control source of the text box on the report ...

=Left$([FieldName], Len([FieldName])-1)

See the Left() and Len() functions in the help file for details.

--
Brendan Reynolds

"Karlwasley" <ka********@aol.com> wrote in message
news:20***************************@mb-m27.aol.com...
HI
I have a ata feild with a stand code EG A23H, there are three letters H, W & C but i do not wish them to be printed in the reports. How can i remove this
letter during a query thatr creates a report so that it is not on the final printout
thanks in advance
Karl

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.