problem with using "SUBSTRING" function in a query

  • Thread starter Thread starter Mike Legaspi
  • Start date Start date
M

Mike Legaspi

I've tried writing and running some queries on access
2000 and was surprised to find out that the SUBSTRING
function doesn't seem to be supported by this version.
I'm wondering if I'm just missing some componenets that
need to be installed to get this function working.

Any suggestion or direction is greatly appreciated.

THanks,
MIke
 
I've tried writing and running some queries on access
2000 and was surprised to find out that the SUBSTRING
function doesn't seem to be supported by this version.
I'm wondering if I'm just missing some componenets that
need to be installed to get this function working.

Any suggestion or direction is greatly appreciated.

THanks,
MIke
Click to expand...

Take a look at the functions Left(), Right() and (in particular)
Mid(). There is no Substring() function in Access VBA.
 
Back
Top