Hi http://www.access-programmers.co.uk/ubb/smile.gif

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

Make a report that displays the fields from the query. You will then be able to control the headers and footers.

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

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

Because thts a stupid cross tab query with no limits to colums http://www.access-programmers.co.uk/ubb/smile.gif thts y http://www.access-programmers.co.uk/ubb/smile.gif

Cheers!
Aqif