Results 1 to 2 of 2
  1. #1
    ayman.maher is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    1

    how select middle characters on string ???

    hii all



    how could i select the middle two characters on a string ?

    i.e if i have astring like '20090305' i'd like to return only '03'

    i used access datasource in my project

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi,

    Use the MID function:

    Mid Function

    Cheers,

Please reply to this thread with any new information or opinions.

Similar Threads

  1. characters in text boxes
    By Matthieu in forum Access
    Replies: 0
    Last Post: 04-08-2010, 11:02 AM
  2. Chinese Characters on Reports
    By caddadd in forum Reports
    Replies: 2
    Last Post: 02-04-2010, 02:46 PM
  3. Extract text from middle of a field
    By AccessNubie in forum Access
    Replies: 3
    Last Post: 11-02-2009, 01:13 PM
  4. replace characters in a string
    By blazixinfo@yahoo.com in forum Access
    Replies: 6
    Last Post: 08-06-2009, 03:36 PM
  5. Special Characters
    By orgelizer in forum Access
    Replies: 0
    Last Post: 03-20-2007, 08:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums