Query: How to Hide/Suppress Column Headers?

  • Thread starter Thread starter Meleah
  • Start date Start date
M

Meleah

I'm writing a simple SQL query utilizing Access.

SELECT Project.pnumber, Project.pname,
Count(Works_On.pno) AS [count]
FROM Project, Works_On
WHERE (((Project.pnumber)=[Works_On].[pno]))
GROUP BY Project.pnumber, Project.pname, 'count';

Is is possible to suppress the column headings from the
query results? If so, how? I'd also like to be able to
do this without using forms if at all possible.

-- Meleah
 
The normal usage is to use Forms to present the data. DatasheetView of
Tables, Queries, etc .. is meant for testing only. You don't see
professionally-developed databases present data using Datasheets.
 
I realize this is an abnormal request. My question was
whether or not it could be done and, if so, how.
-----Original Message-----
The normal usage is to use Forms to present the data. DatasheetView of
Tables, Queries, etc .. is meant for testing only. You don't see
professionally-developed databases present data using Datasheets.

--
HTH
Van T. Dinh
MVP (Access)



I'm writing a simple SQL query utilizing Access.

SELECT Project.pnumber, Project.pname,
Count(Works_On.pno) AS [count]
FROM Project, Works_On
WHERE (((Project.pnumber)=[Works_On].[pno]))
GROUP BY Project.pnumber, Project.pname, 'count';

Is is possible to suppress the column headings from the
query results? If so, how? I'd also like to be able to
do this without using forms if at all possible.

-- Meleah
Click to expand...


.
Click to expand...
 
You can make the Caption of the Column headers blank but the header row (of
grey boxes) is still visible. This can be achieve by placing a single space
in the Caption Property of each Field/Column in the Query.

Alternatively, you can use a Form in ContinuousFormView with just Detail
section and no Labels. You can arrange and Format the bound TextBoxes so
that the ContinuousFormView looks like a Datasheet.

--
HTH
Van T. Dinh
MVP (Access)



Meleah said:
I realize this is an abnormal request. My question was
whether or not it could be done and, if so, how.
-----Original Message-----
The normal usage is to use Forms to present the data. DatasheetView of
Tables, Queries, etc .. is meant for testing only. You don't see
professionally-developed databases present data using Datasheets.

--
HTH
Van T. Dinh
MVP (Access)



I'm writing a simple SQL query utilizing Access.

SELECT Project.pnumber, Project.pname,
Count(Works_On.pno) AS [count]
FROM Project, Works_On
WHERE (((Project.pnumber)=[Works_On].[pno]))
GROUP BY Project.pnumber, Project.pname, 'count';

Is is possible to suppress the column headings from the
query results? If so, how? I'd also like to be able to
do this without using forms if at all possible.

-- Meleah
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top