I loop thu a table to get field names
myArray(iCounter) = "[" & rstTableName.Fields("DJPR-Import") & "]"
into an array as I need them for a query ie
"SELECT DJPR1." & myArray(0) & ", DJPR1.[READY TIME],...
My issue is that if the field name is one word it works ok however when there are two words it comes thu as 'Expr1: DJPR1.[Ready date]' on the query and does not work.
ReadyDate works
Ready Date does not work.
Any ideas why?
Peter
myArray(iCounter) = "[" & rstTableName.Fields("DJPR-Import") & "]"
into an array as I need them for a query ie
"SELECT DJPR1." & myArray(0) & ", DJPR1.[READY TIME],...
My issue is that if the field name is one word it works ok however when there are two words it comes thu as 'Expr1: DJPR1.[Ready date]' on the query and does not work.
ReadyDate works
Ready Date does not work.
Any ideas why?
Peter