| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
mid function in ms query
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 |
|
#2
|
|||
|
|||
|
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. "suhair" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
| Query of External Data | Excel Discussion (Misc queries) | |||
| Microsoft Query Help | Excel Worksheet Functions | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Hybrid Mode
