Hi,
I am using MS Query 2002 at my work place. I have trying to alter a view so that I could rename two columns in that view, but have been futile in all my efforts. This is the query I have been using:

alter view Report."<Seeyle_Centerubmeter>Physical Plant""("timestamp","I a dmd","I b dmd","I c dmd",kWD,"kWH DEL","kWh Reverse") as select "timestamp","SD103 SWinDemand","SD104 SWinDemand","SD105 SWinDemand","MI42 Value 2","MI43 Value 1","MI43 Value 2" AS "("timestamp","I a dmd","I b dmd","I c dmd",kWD,"kWH imp","kWh exp") as select "timestamp","SD103 SWinDemand","SD104 SWinDemand","SD105 SWinDemand","MI42 Value 2","MI43 Value 1","MI43 Value 2"

Please correct me if I am doing anything wrong in the query.
Thanks.
DBA1977