field names

[BrightIdeas]

As the result of querying a crosstab query , I have a fieldname
rejected by Microsoft
the fieldname is simliar to this

qryACE +X + Y + Z .qryACE + X.Year.Year

Access says the field name is not valid

would

qryA.qryX.Year.Year

be not valid also ?

 

[John Spencer]

The only way to make that a valid column name would be to surround the entire
thing with square brackets [].
[qryACE +X + Y + Z .qryACE + X.Year.Year]

 

[David F Cox]

Year is an Access reserved word.
[year] might work