Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
RENAMING FIELD NAME IN QUERY
- Thread starter 99Chuck99
- Start date
I doubt you will get this to work and I'm not sure why you would want to.
You could modify the SQL property of a saved query or possibly create a crosstab where field values become column names.
Personally, I don't ever use field names with symbols and my names always begin with a letter.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
You could modify the SQL property of a saved query or possibly create a crosstab where field values become column names.
Personally, I don't ever use field names with symbols and my names always begin with a letter.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
- Status
Similar threads
- Question
