Results 1 to 5 of 5
  1. #1
    stalk is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    May 2014
    Posts
    143

    What function to use to remove extra spaces from a list?

    I have a query that filters a field. All the values are working except one.."stalk-intl ,,,"


    In("stalk", "stalk-intl", "stalk-dm", "stalk-intl ,,,")

    What function can I use in this query to remove the special character or spaces etc and retrieve the records that has all the list of values?

    Thank you

  2. #2
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Can you elaborate on your question a bit more? I don't understand what it is you're trying to do.

    What does the table of data look like? What is your full current query? What exactly should the results of the query look like?

  3. #3
    stalk is offline Competent Performer
    Windows 8 Access 2003
    Join Date
    May 2014
    Posts
    143
    My query select * from temp where reason In("stalk", "stalk-intl", "stalk-dm", "stalk-intl ,,,");

    In my results I can see all the records except the records that have "stalk-intl ,,," . When I open the table in the list view I don't see the difference in values but when I try to apply the filter I noticed the extra spaces. how can I handle this in my query to pull all values which has extra spaces?

  4. #4
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Can you post your db?

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    why not use

    select * from temp where reason Like "stalk*"

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

Similar Threads

  1. Replies: 12
    Last Post: 04-06-2018, 01:46 PM
  2. Replies: 9
    Last Post: 02-25-2017, 09:15 PM
  3. How to remove extra spaces from a field?
    By accessmatt in forum Queries
    Replies: 1
    Last Post: 09-22-2014, 06:57 AM
  4. Replies: 2
    Last Post: 04-11-2013, 06:36 PM
  5. Remove extra page from report?
    By sunny in forum Reports
    Replies: 2
    Last Post: 10-17-2012, 11:30 AM

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