It is quite simple to rename a column in Access 2000 via doing the following in access: Newname:fieldname
However does anyone know how to rename the field utilsing a variable.
Ie: There is a form with a text box control, it is called DateTo30June
In the query there is a parameter set: Form!formname!DateTo30June
When I run the query, I would like to do somthing similar:
Field1 Field2 Field3 DateTo30June:Field4
Where by, once query is run The column name of field 4 is the variable: DateTo30June
Is this possible,