Link to home
Start Free TrialLog in
Avatar of doyle007
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,
ASKER CERTIFIED SOLUTION
Avatar of harfang
harfang
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial