I enter "103*" in the criteria for a field in a query. The results work fine. When I try to use a prompt instead, as the criteria and type "103*" in...

How do I set up a wild card query to look for names "Like" in the data base. If I'm looking for a customer it could start with any letter of the...

I have a table I want to look for matching records in. One of the options that data entry people have is to enter wildcards into records if they can't read...

Hi all, I have a query where i want to pick all the records with 'denied access' in them, the records could be as follows; denied access denied me...

Hi I have created a query from form, I am able to use the * wildcard if I wish so all is well so far. What I would like to do is have the * as the default...

I need to use a wildcard type search to mark records that have a particular letter in a larger field: IIf(="*V*",1,0). In this example, the format of the...

Hi, This is my SQL QUERY: SELECT Table1.NAME, Table2.NAME FROM Table1 LEFT JOIN Table2 ON Table1.NAME = Table2.NAME; The issue is that Table2 has NAME...

I have subquery and would like to use a wildcard for all records that begin with data in subquery. How do I do this? The subquery except that I need it to...

I'm using a form for the user to input a part number exactly as it is. ex. #7-7 I then have a query that runs based on the value entered on the form. It...

I have a query set to prompt the user for input, it searches 2 fields and then pulls up the record. I am wondering how I can get it so you can only type part...

The wildcard search is not working for the SHOP field in the following code. I want to search the SHOP field for all strings that contain an A. I have this...

Table A xlb114r xj20aaa xsw3456qt Table B

Hi, I have a wildcard search which is linked to a form with 2 textboxes on it which allow my users to enter search criteria. My current SQL statement looks...

Hi, I'm trying to design a sort of search panel where the user types in the first few letters of a customer's name into a textbox, clicks a command button,...

I'm running Access 2003. I've looked at the posts here and thought I had done the wildcard correctly but I am getting no results for data that I know does...

I was wondring if it is possible to do a wildcard on an inner join and if so what would be the correct SQL to get the wildcard to function? The query im...

My query looks at a textbox which is a customer number from a form as part of an IIF statement as criteria in a query. IIF(isnull(), wildcard number ,) I...

Hi, I have a fairly simple database based on customers, visits, orders etc. I have set up a report based on a query that will tell me on which dates customers...

Is it possible to use single charcater wildcards in "InStr"? In this case I wanted to search for a "/" preceeded and followed by 2 numerical characters but it...

I did a query where I want to add on a certain amount of months to a date depending on the contents of another field. Here is the statement I...