mid function in ms query

  • Thread starter Thread starter suhair
  • Start date Start date
S

suhair

Hello,
i know that the funtion mid works in Excel.
i need to use this function in Ms Query, (get external
data, and edit my query there).
is there any similar function
Thank you
Suhair
 
Suhair,

Try substr(string,startpostion,length)
eg. substr(mystring, 1, 4)

It's a bit of a shot in the dark but it might work.
 
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

Excel Query setup 0
Access #Error & Excel Pivot 0
filter & pivot table 3
OLAP Creation in Excel / MS Query -- .cub files 1
CountIf - mid() 3
External data link to Access - no linked tables? 3
MS Query Window 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top