473,322 Members | 1,232 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How do I create a query for a partial match?

1
I have a Master Table (tbl1) with part numbers (PNs)and a table of PNs where the single character suffix was dropped (tbl2).
I need to create a query where the PN characters in tbl2 match the PN characters in tbl1 and can have an extra character.
I have tried various sequels but continue to either get too many PNs or no PNs.
How do I create a query that will give me basically the entire PN (tbl2) less 1 character?
Dec 22 '14 #1
1 965
Luuk
1,047 Expert 1GB
i did not know the answer too,
but googling for: 'sql like wildcard access'
showed this site:
http://www.techonthenet.com/access/queries/like.php

so, the answer is:
use a '?' with LIKE
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM tbl1 WHERE part_number like 'PN1234?'
should give all PN's that start with 'PN1234' + an extra character
Dec 22 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Christian Staffe | last post by:
Hi, I would like to check for a partial match between an input string and a regular expression using the Regex class in .NET. By partial match, I mean that the input string could not yet be...
2
by: Andrew Chalk | last post by:
I have a customer who wants to SELECT records based on a partial match in a text field. For example, in a list of telephone numbers they want to search for all records that contain the digits '777'...
2
by: mael.iosa | last post by:
Hi, I'm new to this group and fairly new to Access. I have a bunch of data, and after several other queries, I generate the following query which has two fields: Bin, Time 20 3.5 20 3.9 20...
4
by: wecka | last post by:
Hello All, Does any one know how to use the form filter in Access to provide partial match? When you choose to "form filter," all text boxes will convert to combo boxes where you can choose from...
7
by: Jim | last post by:
How do I program visual basic to create a "Find Unmatched Query"? I have two tables: - TodaysImport - YesterdaysImport Both tables have the same 6 fields: - User
3
by: danielleissy | last post by:
Firstly i would like to know the difference between Keyword searching using SQL and partial matching of a search. I have to search for a book by key word in the book title. But allow TWO key words...
16
by: vorlonfear | last post by:
I have been working on this for a while now and I wanted to see if someone could assist me. I have 2 tables each with 5 fields. 4 of the fields are 2 character strings, then the final field is the...
4
by: Pat Rowe | last post by:
Relative Newbie w/ a stumper! Any help is appreciated. Thanks! I have two tables that I have imported to access. I'd like to query between these two tables for records that have a shared last...
4
Fspinelli
by: Fspinelli | last post by:
I don't know any other way to explain this but: I have a query by form (queries my customer table) that by entering a few letters of a company's name in the search field will bring up results in...
1
by: zivronen | last post by:
Hello all. my question is how can i pass from one page with a form feild to a "Create query" in another page. what i am trying to do is make the Table name in the Create page to have the value...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.