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.
 

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

Is there a function like Substring? 3
Using SUBSTRING in query 2
How do I find quotation marks in a string using INSTR? String exa. 2
programming complex query/report 3
Use In() Expression as Query criteria with guts from Function 1
Left function 2
String Manipulation - Substring, VB function Left, "length safe" Substring 6
UPC check digit? 16

Back
Top