| Chat with a LIVE Microsoft
Access Expert! |
||||
|
|
|||
|
||||
|
||||
|
#1
06-22-2005, 08:17 AM
|
|||
|
|||
|
Criteria matches 1st part of another Field
undefinedHi, apologies if this has been answered before but can't find anything relevant!
Trying to match one field to the first 5 digits in another i.e. Field 1 = 55667 Field 2 = 5566785431 so would want to match the 1st five digits in field 2... Any ideas? Thanks 
|
| Sponsored Links |
|
#2
06-22-2005, 01:16 PM
|
|||
|
|||
|
If your field is TEXT, NOT NUMBER, you can use the Left() function.
fld1 = Left(fld2, 5)
__________________
Bridge Players Still Know All the Tricks
|
|
#3
06-23-2005, 07:54 AM
|
|||
|
|||
|
Thanks
Pat, thanks for your help!
Cheers Dan
|
|
#4
06-23-2005, 07:54 AM
|
|||
|
|||
|
Thanks
Pat, thanks for your help!
Cheers Dan
|
| Sponsored Links |
 |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Report With Multiple Image Pages Following Each Group | chaddiesel | Reports | 0 | 05-30-2005 03:16 PM |
| Double criteria on one field problem | jancliff | Queries | 1 | 05-27-2005 12:26 PM |
| Passing criteria to a query field | tjs206 | Queries | 1 | 08-26-2002 02:01 PM |
| part of criteria taken from text box from a form | ivanteo | Queries | 2 | 05-05-2002 10:57 PM |
Linear Mode
