Query: How to Hide/Suppress Column Headers?

[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

 

[Van T. Dinh]

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.

 

[Meleah]

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

.

 

[Van T. Dinh]

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)

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

.