Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 23rd, 2004, 11:53 AM
Registered User
Join Date: Sep 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default In Access - look at portion of string

I have a field that has a number somewhere in it. I want to know that number so my query can tell Access to do an action. If the number is 27 print 100 but if the number is 54 print 100. The field looks like this "variable number of characters 27 variable number of characters"
Can you tell me how to do this?
Thank you for your time.

Old September 23rd, 2004, 03:06 PM
Authorized User
Join Date: Jul 2004
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts


INSTR function, searches for a string within a string, and returns the position where it starts at or 0.

if it returns > 0 then it found the string

Hope that helps!

Similar Threads
Thread Thread Starter Forum Replies Last Post
xslt to update only a portion of a page CesarSJU XSLT 4 April 29th, 2008 06:29 AM
HTML portion of aspx file SKhna ASP.NET 2.0 Basics 3 March 25th, 2008 10:52 AM
Extracting portion of XML ** Need help asap** aintvoguish XSLT 3 December 20th, 2007 09:12 AM
Want to print some portion of the web page. jigu_2811 C# 1 October 17th, 2006 08:16 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.