Criteria

T

TJAC

I have a table that I link to that contains information I would like to pull.
The table has about 400,000 records. Within the column I would like to pull
from there are records that are "CS" "1234" or "10CB" I am only interested
in the ones that contain two numbers and then two letters. This field is a
text field. I cannot figure out a way to pull only those without creating a
make table and then appending that information.

Any help would be great!
Thanks!
 
K

KARL DEWEY

In the design view of your query put this in the criteria row for the text
field --
"CS" or "1234" or "10CB"

That is if the field contains that information only. If that information is
a part of the data in the field then use --
Like "*"&"CS"&"*" or Like "*"& "1234" & "*" or Like "*" & "10CB" & "*"
 
A

aaron.kempf

uh you can write a function if you wanted.. write it in VBA and then
just use it in a query
 
Top