How to change row in query

[amator]

Hi
How is it possible to change row in query column title?

I have query which look like this:
[number] [start time] [end time]
1224345 12.6.2007 13.6.2007

I want that my query should look like this:
[number] [start [end
time] time]
1224345 12.6.2007 13.6.2007

 

[neileg]

Why does this matter? You should not be viewing data in a query, it should be in a form or a report. You have full control over your headings in either of these.

 

[Dennisk]

if you want to chage the column heading then prefix the field name with whatever you want to call it and a colon eg

you have a field called amount and you want to call it Fred

use

Fred: Amount