Need the equivalent of a substring function

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

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?
 
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


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

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

Lorraine said:
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


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

Lorraine said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top