Hi,
I am using MS Query 2002 at my work place. I have a view and I need to change the name of the columns in that view. I am unable to do that even though I am logged in as "DBA". This is the way I am giving my query as:
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"
Its been frustrating, since I have been trying for more than 2 days!!! Please HELP!!!!!