|
| 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
April 11th, 2008, 07:41 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
How to select characters in a field?
I need to create criteria in a query. It must select records where the first
3 characters in the field are the same as 3 characters in a text box on some form. I'm sure this is an easy one. I've done this before...somewhere...but I can't recall how to do it! -- Chris 
|
|
#2
April 11th, 2008, 08:00 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
How to select characters in a field?
Try
Field: SomeField Criteria: Like Left([Forms]![Name of your Form]![Name of Control],3) & "*" SELECT ... FROM ... WHERE [SomeField] Like Left([Forms]![Name of Form]![Name of Control],3) & "*" John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County Steel Banana wrote: I need to create criteria in a query. It must select records where the first 3 characters in the field are the same as 3 characters in a text box on some form. I'm sure this is an easy one. I've done this before...somewhere...but I can't recall how to do it!
|
|
#3
April 11th, 2008, 08:04 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
How to select characters in a field?
Like [Forms]![SomeFormName]![TextBoxName] & "*"
-- KARL DEWEY Build a little - Test a little "Steel Banana" wrote: I need to create criteria in a query. It must select records where the first 3 characters in the field are the same as 3 characters in a text box on some form. I'm sure this is an easy one. I've done this before...somewhere...but I can't recall how to do it! -- Chris
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
