+ Reply to Thread
Results 1 to 5 of 5

Select Query with variable string containing commas

  1. 11-11-2021, 11:12 AM #1
    nigelog
    nigelog is offline
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Select Query with variable string containing commas

    I'm not sure whether my continued problem with this query is the syntax of the line itself or the fact the search string contains commas

    typical string that has exact matches in access db
    Please Login or Register  to view this content.
    I've lost track of the variations I've tried

    Any pointers appreciated

    I've even tried filtering the record set with one it's elements and now says 'No Records to Return'
    Please Login or Register  to view this content.
    Last edited by nigelog; 11-15-2021 at 12:25 PM.
    Reply With QuoteRegister To Reply
  2. 11-11-2021, 10:06 PM #2
    Greg M
    Greg M is offline
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Select Query with variable string containing commas

    Hi again Nigel,

    Just an untested shot-in-the-dark:

    Please Login or Register  to view this content.

    Hope this helps.

    Best regards,

    Greg M
    Reply With QuoteRegister To Reply
  3. 11-12-2021, 07:15 AM #3
    rorya
    rorya is offline
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,901

    Re: Select Query with variable string containing commas

    Does that string actually match the Customer field?
    Rory
    Reply With QuoteRegister To Reply
  4. 11-15-2021, 12:25 PM #4
    nigelog
    nigelog is offline
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Select Query with variable string containing commas

    @ Greg and Rory
    I settled on filtering on the first field larger than a single character
    Please Login or Register  to view this content.
    There were anomolies in the database that were not helping...sorted now. Thanks for help
    Reply With QuoteRegister To Reply
  5. 11-15-2021, 04:24 PM #5
    Greg M
    Greg M is offline
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Select Query with variable string containing commas

    Hi again Nigel,

    Many thanks for your feedback and also for the (undeserved!) Reputation increase - much appreciated!

    Glad to hear that things seem to be working correctly for you now.

    Best regards,

    Greg M
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove numerous trailing commas from text string that contains commas
    By JenSven1 in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2016, 10:19 PM
  2. Remove numerous trailing commas from text string that contains commas
    By JenSven1 in forum The Water Cooler
    Replies: 1
    Last Post: 05-23-2016, 11:05 AM
  3. How to get query result into string variable
    By Mahi007 in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-10-2015, 05:53 PM
  4. Transferring a dynamically named string variable to another string variable.
    By Concorde Rules in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2012, 04:08 AM
  5. Separate string by commas
    By antoni in forum Excel General
    Replies: 2
    Last Post: 10-03-2009, 01:51 AM
  6. count commas within a string
    By excelsteve in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2007, 08:16 AM
  7. removing commas from a string
    By TheIrishThug in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2005, 01:50 PM

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1