Limiting A Query by Using a text format

B

Brad

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
 
B

Brad

Rob,

Works perfect!

Thank you for your help.

Brad

Rob Parker said:
Like "[a-z][a-z]#######"

Rob

Brad said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joins and Query Speed 1
filter for values in another table 5
Formatting date gives bad results in query 2
UNION query changes results after close and reopen 1
Parameter Query for a Text Field 4
How to populate a column in a row based on a value in another colu 3
match values 2
Isolating records in query 3

Top