Need the equivalent of a substring function

[Guest]

I have a field that has data in the format of 2 alpha characters followed by
5 digits. I want to query the field based on the first 2 digits (the 3rd and
4th characters). I was going to use a SUBSTRING function but Access doesn't
recognize it. What is the equivelant function used in Access?

 

[Guest]

The function Mid([YourString],3,2) will give you characters 3 and 4

 

[Guest]

Dennis,
Thanks so much. Say, is there a site where I can look up the various
functions used by Access so I don't have to come to this site for such
trivial stuff?
--
Lorraine

The function Mid([YourString],3,2) will give you characters 3 and 4

I have a field that has data in the format of 2 alpha characters followed by
5 digits. I want to query the field based on the first 2 digits (the 3rd and
4th characters). I was going to use a SUBSTRING function but Access doesn't
recognize it. What is the equivelant function used in Access?

 

[Guest]

Help in Access and help in VBA for access should have all the stuff you need.
I suppose its just supplying the right keywords in the search to get the help
you need.

Dennis,
Thanks so much. Say, is there a site where I can look up the various
functions used by Access so I don't have to come to this site for such
trivial stuff?
--
Lorraine

The function Mid([YourString],3,2) will give you characters 3 and 4

I have a field that has data in the format of 2 alpha characters followed by
5 digits. I want to query the field based on the first 2 digits (the 3rd and
4th characters). I was going to use a SUBSTRING function but Access doesn't
recognize it. What is the equivelant function used in Access?