Results 1 to 3 of 3
  1. 06-26-2024, 03:39 PM #1
    LittleRock Z
    LittleRock Z is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2024
    Posts
    18

    Post what is the string function to test first character on the left

    I want to test the first 3 characters of a field in a record and cant remember the syntax,
    Reply With Quote Reply With Quote
  2. 06-26-2024, 04:05 PM #2
    isladogs's Avatar
    isladogs
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Left(FieldName,3)
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!
    Reply With Quote Reply With Quote
  3. 06-27-2024, 12:38 AM #3
    Welshgasman
    Welshgasman is offline VIP
    Windows 11 Access 2019
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    I have Google on this laptop.

    https://www.google.com/search?q=the+...hrome&ie=UTF-8
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Count first character of string
    By Vaporhead in forum Queries
    Replies: 11
    Last Post: 04-03-2024, 08:47 AM
  2. Checking if a character in a string exists at the end of a variable length string and replacing.
    By NightWalker in forum Programming
    Replies: 3
    Last Post: 07-20-2020, 01:04 PM
  3. Inverted Left function - how to exclude string with variable length
    By DSam in forum Import/Export Data
    Replies: 7
    Last Post: 09-23-2016, 01:04 PM
  4. How do I return last character in a string?
    By SSgtBarry in forum Queries
    Replies: 4
    Last Post: 06-22-2014, 08:10 PM
  5. Test String test besed on table data
    By igourine in forum Programming
    Replies: 3
    Last Post: 12-01-2013, 06:16 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums