How do I use Access using substr in a query?

Answer by  Fisherman (19)

In access substr function is not supported. Mid function is its replacement. You have to use MID(string,start,length) function to get the desired results.

Answer by  detour (44)

You can use substr in a query in Access by using Mid() function: same parameters as substring() so instead of the + symbol use the & symbol to concatenate the strings.

Answer by  steve73 (52)

In Access the substr function is written as Mid(). The parameters are Mid(field,start,end). Other functions available are Right(), Left(), Instr() and Len(). Instr will search a field for a pattern of characters without having to specify absolute positions. So to find a row with 'MR' in the first 2 positions -> Select column_name from table where Mid(column_name,1,2) = 'MR'.

Answer by  hemi (32)

You can use substr in a query in Access by using Mid() function: same parameters as substring() so instead of the + symbol use the & symbol to concatenate the strings. Thus access is going well with the standard sql norm I will give an sql example as explanation: SELECT substr(cloumnname, beginpos, lengthofsubstring)...

Answer by  gigo (1706)

Thus access is going well with the standard sql norm I will give an sql example as explanation: SELECT substr(cloumnname, beginpos, lengthofsubstring)...

Answer by  fishlover49 (643)

you would most probably have to use either DCOUNT, DLOOKUP or DMAX to do your query. Both methods can be found in the help section of the program or online