doyle007
asked on
rename a column in Access 2000 query, utising a variable from a form
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,
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,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.