I can't fathom this one. I have a field called Current Status in a table. When I run a query I want to rename the field like this
STATUS:Current Status
No matter what I do, the field remains Current Status. I have tried putting square brackets around like this STATUS:[Current Status] but Access throws them out. Every other field I have tried is no problem.
If I add another field in the query and try to call that STATUS:AnotherField, it renames that other field to Current Status, not STATUS. Even if I remove Current Status from the query!
Any body understand what is happening?
STATUS:Current Status
No matter what I do, the field remains Current Status. I have tried putting square brackets around like this STATUS:[Current Status] but Access throws them out. Every other field I have tried is no problem.
If I add another field in the query and try to call that STATUS:AnotherField, it renames that other field to Current Status, not STATUS. Even if I remove Current Status from the query!
Any body understand what is happening?