I need help changing query Titles/headings

[chubby]

I'm using 10 queries as subreports in one report. Thanks Lonnie Johnson. Now I have a new problem!!! How can I get rid of those queries heading titles in my report. I got rid of the all borders, lines and color but not the titles. I just want the Numbers to show in my reports. My end-user wants them label differently. "HELP"

Example of the headings from the query
PG_tbl CountOfPG_tbl
O1 5
O2 7
O3 2
ETC...

 

[tlbroadbent]

To rename the column title in the query designer, place the desired name with a ":" in front of the column name like this.

[tt]Field: PG_tbl PG_Cnt: PG_tbl
Table: tbl tbl
Total: Group By Count[/tt]

Or in the SQL statement use "As Alias_Name" to rename a column.

Select PG_tbl, count(PG_tbl) As PG_Cnt
From tbl Group By PG_tbl Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm