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

G

Guest

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.
 
D

Douglas J. Steele

Don't know for certain, but see whether

[USE:MIN]: Sum of usg_mins

works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
use a colon in a query column title 9
Max length of Column Heading in Crosstab 3
Duplicates not added in a Cross Tab Query 4
Can I use "Group By" for a column in the Query Grid? 2
cannot use the crosstab of a non-fixed column as a subquery 3
summing in a query or report 4
Crosstab Query results/ Sum 7

Top