field names

  • Thread starter Thread starter BrightIdeas
  • Start date Start date
B

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 ?
 
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

USING PARAMETERS IN A CROSSTAB QUERY 4
determining if a field should be included 6
Dynamic Crosstab Problem 2
Crosstab query error 1
crosstab query parameters for dates 1
Crosstab query problem 2
Access Query Optimizer error 5
sql SELECT..From a linked Crosstab 1

Back
Top