Hi,
TABLE1
I have one table which has a GL code field with numbers 1 -99.
QUERY1
I have a query which separates a Divisional code into its subsections, from this I have one field called GL code which is created using mid([GL],9,2) to pull out the two digits which represent GL code.
Example
Divisional code is Q1333123234 and the expression draws out 32
I want to create a new query to match this 32 in QUERY1 with 32 [GL] code in Table1 - when I try and link these fields I get:
'Type mismatch in expression'
Any help would be great thanks