Query Column Reserved Word

[stickandrock]

I have a query that I would like to use the verbage "Detail" for the output
column name. When I do that the column name is displayed as Field0. Is
"Detail" reserved in some way.... If I change the verbage to anything other
than "Detail" it display accordingly. So I know it is not a syntax type of
error.

Any Thoughts....

Thanks

 

[Tom van Stiphout]

On Wed, 25 Mar 2009 06:38:08 -0700, stickandrock

It is indeed a reserved word.

-Tom.
Microsoft Access MVP

 

[KARL DEWEY]

Do you already have a field named Detail? Access renames a field if you try
to have two the same.

 

[stickandrock]

That is what I thought.....

I have come up with another description that will work....

Thanks,
Don

 

[fredg]

I have a query that I would like to use the verbage "Detail" for the output
column name. When I do that the column name is displayed as Field0. Is
"Detail" reserved in some way.... If I change the verbage to anything other
than "Detail" it display accordingly. So I know it is not a syntax type of
error.

Any Thoughts....

Thanks

For a list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html