design grid total line question.

  • Thread starter Thread starter JH
  • Start date Start date
J

JH

In the design grid I have created a total line that has several group bys and
firsts. I get the data I need but the column headings now say firstof and
then the field name. Is there a way to eliminate the 'firstof' part of the
newly created field name?
Thanks for your help.
 
If you want the original field names then this is a bit problematic.

You can try something like the following. It may work for you depending on
your query set up.

FIeld: MyField: MyField
Table: MyTable
Total: First

If you are willing to settle for close to the original names then add an
underscore to the alias - either at the end or in the middle.
FIeld: MyField_: MyField
Table: MyTable
Total: First

or

FIeld: My_Field: MyField
Table: MyTable
Total: First

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Back
Top