Query name during printing

[aqif]

Hi

I want to print a query and when I print that it displays the name of the query on the top and then Page# on the bottom. Is it possible to change the name caption of the query at runtime n also the footer remarks?I want this because the same query has got different parameters and I want to change the name of query according to parameter value. For some reasons i can't make a report for that query. Any help regarding customised printing of query will be appreciated.

Cheers!
Aqif

 

[aqif]

Thanxx Pat but I think i mentioned in my original question also that I can't make a report of it n i have the choice of only printing query. I just want to change the caption of query while printing.

Cheers!
Aqif

 

[Rich]

Why can't you make a report from your query, that's what they are for.

 

[aqif]

Because thts a stupid cross tab query with no limits to colums

thts y

Cheers!
Aqif