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
|
|||
|
|||
Limiting A Query by Using a text format
All,
I have a License_Text_ ID field with several different types of license formats. I would like to limit a query to only returning IDs with a format of "LL#######". Where L=Letter and #=Number. I need the query to only return those IDs with this exact format. What can I put in the query Criteria field to accomplish this? Thanks in advance for your assistance. Brad |
#2
|
|||
|
|||
Limiting A Query by Using a text format
Like "[a-z][a-z]#######"
Rob "Brad" wrote in message ... All, I have a License_Text_ ID field with several different types of license formats. I would like to limit a query to only returning IDs with a format of "LL#######". Where L=Letter and #=Number. I need the query to only return those IDs with this exact format. What can I put in the query Criteria field to accomplish this? Thanks in advance for your assistance. Brad |
#3
|
|||
|
|||
Limiting A Query by Using a text format
Rob,
Works perfect! Thank you for your help. Brad "Rob Parker" wrote in message ... Like "[a-z][a-z]#######" Rob "Brad" wrote in message ... All, I have a License_Text_ ID field with several different types of license formats. I would like to limit a query to only returning IDs with a format of "LL#######". Where L=Letter and #=Number. I need the query to only return those IDs with this exact format. What can I put in the query Criteria field to accomplish this? Thanks in advance for your assistance. Brad |
Thread Tools | |
Display Modes | |
|
|