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

Displaying the Right/Left x number of characters

P: 2
Hi

In a query in Access 97, I am trying to just display a certain number of characters from the right of the field.
I had an old query with this in, but deleted it long ago. Can someone point me in the right direction? What do I need to add in the query to show this?

Thanks
May 25 '07 #1
Share this Question
Share on Google+
3 Replies

missinglinq
Expert 2.5K+
P: 3,532
You need to use the Right function:

AnyString = "The Scripts"
Right(AnyString, 7)

Returns "Scripts".
May 25 '07 #2

P: 2
Thanks for that. Much appreciated!

I'm sure there was a way of doing it in the design mode of the query though, by entering something into the criteria line in design view, in the column you want to display x characters left/right for. Any ideas?

Thanks
May 25 '07 #3

NeoPa
Expert Mod 15k+
P: 31,770
=Right([Field],x) in the ControlSource of the control you're working with.
May 26 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.