Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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" & "*"
 
uh you can write a function if you wanted.. write it in VBA and then
just use it in a query
 
You must log in or register to reply here.

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

Criteria in Query 1
Access Dcount (multiple criteria) 3
Multiple field primary key problem 2
Using the "Forms Object" on more than field in a query table 2
Field by Field Comparison 3
Running Query on memo field - character limit 4
Lookup field 5
How to Autofill a field based on a table of values 7

Back
Top