Hello!

Is it possible to use MID fiunction in SQL Query?

Or is there any other way to get it done..
StrSQL = " SELECT " & _
" j.Accno, SUM(j.db)DR, SUM(j.cr)CR, Month(j.Trdate)Month,
LEFT(j.tktno,4)ARL"
I would like to get "MID(j.Accno, 5, 3)Loc"

three charecters from Accno starting fifth character.

Thanks