|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 10th, 2004, 02:26 PM
|
|||
|
|||
Wildcard yields no records
I have a table with a field I want to search for using a
wildcard. My query criteria is [Enter Name]. The field property is Text and there are no masks on it. To get Lockwood, Lock, Locke etc. I've typed Lock* as the variable but the query returns no records. What am I doing wrong? 
|
|
#2
August 10th, 2004, 03:04 PM
|
|||
|
|||
|
Wildcard yields no records
Use [Enter Name] & "*"
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Sarah" wrote in message ... I have a table with a field I want to search for using a wildcard. My query criteria is [Enter Name]. The field property is Text and there are no masks on it. To get Lockwood, Lock, Locke etc. I've typed Lock* as the variable but the query returns no records. What am I doing wrong?
|
|
#3
August 10th, 2004, 03:58 PM
|
|||
|
|||
|
Wildcard yields no records
Well that didn't work but I kept trying and searching and
found that this did: Like [Enter Name] & "*" You got me on the right path- thanks! -----Original Message----- Use [Enter Name] & "*" -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Sarah" wrote in message ... I have a table with a field I want to search for using a wildcard. My query criteria is [Enter Name]. The field property is Text and there are no masks on it. To get Lockwood, Lock, Locke etc. I've typed Lock* as the variable but the query returns no records. What am I doing wrong? .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| selecting multiple records | sps | Using Forms | 3 | August 3rd, 2004 08:22 PM |
| append Query duplicating records | Alex | Running & Setting Up Queries | 1 | July 8th, 2004 01:31 PM |
| Query combining multiple records from one table can't add records | Clint Marshall | Running & Setting Up Queries | 4 | July 8th, 2004 01:25 PM |
| Copying new records | John | General Discussion | 0 | June 25th, 2004 04:02 PM |
| How to Manipulate the group and sorting in a report? | Jorge Novoa | Using Forms | 2 | June 9th, 2004 01:12 AM |
Linear Mode
