Results 1 to 2 of 2

Imported data set contains faulty charaters

  1. #1
    Chethead is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    1

    Imported data set contains faulty charaters


    Hello,

    New here and to Access. I've taken a couple of classes and purchased a couple of books but still fairly lost.

    I'm writing a query that will return quantity of 1" bolts. I have succesfully returned 1/2" and 3/4" bolts (like "*1/2* bolts*) and (like "*3/4* bolts*).

    I have found out that when I imported my data from excel, I probably should have took notice of any special characters, especially " (inches) and # (wire size) as I have a lot of items with these characters.

    That being said, I tried many combinations that are supposed to be only one wildcard in lieu of the ", but I cannot get the query to return only 1" bolts. (like "*1* bolts*) unfortunately returns 1/2, 1, 1 1/4 and 1 1/2.

    Any thoughts?

    Thank you,

    Rob

  2. #2
    isladogs's Avatar
    isladogs is offline Very intense programming
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,476
    Suggest you run a find and replace on characters like " & # and * as those will cause you issues.
    For example, if " is only used to denote inch then run a query to update it using Replace([Your Field Name],"""", " inch")
    NOTE: the """" will actually look for "

    Once you've done that, your wildcard could be *1 inch* which will exclude items like 1 1/4 inch

    OR you could change everything to mm!
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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

Similar Threads

  1. Show new imported data ?
    By Lukael in forum Programming
    Replies: 16
    Last Post: 03-09-2016, 12:45 PM
  2. Replies: 4
    Last Post: 11-11-2013, 08:39 AM
  3. Imported data has different ID
    By cheyanne in forum Forms
    Replies: 48
    Last Post: 05-28-2012, 09:47 AM
  4. Faulty connection with the form table
    By szymon189 in forum Access
    Replies: 0
    Last Post: 02-02-2011, 10:31 AM
  5. Help with imported data
    By bubbasheeko in forum Queries
    Replies: 0
    Last Post: 01-12-2007, 07:12 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
  •  
Tech Forums: Microsoft Office Forums