Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

Can I use a colon in the text of a query column heading?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AndyG - 16 Jul 2007 14:16 GMT
Can I, and if so, then how, have a colon in the text of a column heading, in
a query?
I now have the following
USE: Sum of usg_mins
And when I run the query the header appears as
USE
with the value of the Sum of usg_mins in the detail lines below it.
What I would like to do is
When I run the query, to have the following appear in the header
USE:MIN
with the value of the Sum of usg_mins in the detail lines below it.
Douglas J. Steele - 16 Jul 2007 14:38 GMT
Don't know for certain, but see whether

[USE:MIN]: Sum of usg_mins

works.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Can I, and if so, then how, have a colon in the text of a column heading,
> in
[quoted text clipped - 8 lines]
> USE:MIN
> with the value of the Sum of usg_mins in the detail lines below it.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.