PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?QW5keUc=?=
Guest
Posts: n/a
 
      16th Jul 2007
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.

 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      16th Jul 2007
Don't know for certain, but see whether

[USE:MIN]: Sum of usg_mins

works.

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


"AndyG" <(E-Mail Removed)> wrote in message
news:32402A74-F0CD-4AF6-A8A4-(E-Mail Removed)...
> 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.
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
crosstab query column heading inungh Microsoft Access Queries 2 2nd Feb 2010 10:46 PM
Column Heading Query KiwiBrian Microsoft Outlook 3 23rd Sep 2009 12:48 PM
use a colon in a query column title ndt Microsoft Access 9 4th Apr 2008 12:56 AM
Edit Column Heading for a query =?Utf-8?B?Um9nZXI=?= Microsoft Excel Worksheet Functions 0 24th Apr 2007 07:14 PM
Query on Column Heading =?Utf-8?B?dmpyaXp6bw==?= Microsoft Access 1 26th Oct 2004 07:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:18 AM.