John Skolits
askolits at nni.com
Tue May 20 07:42:39 CDT 2008
When using a query, I want an alternate column heading to what's provided in the field's caption property located in the table's design. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Tuesday, May 20, 2008 8:18 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Query Column Headings -Table's Caption Property Vs aQuery's Alias You want a second caption for the query column, correct? You can do it manually in the query design window. Does that help? Susan H. >I have some tables where I have added captions in the Table's design. > When I run a query against the table, I see those captions as the column > headings instead of the field name. Good, this is what I want. > But there are a few query headings I would like to change and still keep > the > table's captions the table's design. > > You would think that you would simply use an alias prefix in the grid's > field name (i.e. EXPR1:FieldName) > > But when you run the query, it still shows the caption listed in the > table's > design not 'EXPR1'. > > I thought maybe there was a <Tools><Options> setting but I didn't find > anything. Also nothing in the query's properties (as far as I could see). > > Anyone have any thoughts? > > John Skolits > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com