group rows in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using access 2003. I have a query that pulls data based on group by and
first in the total row and the data is good. My problem is when I create a
table based on this data some of the field names become firstof..... Is there
a way to eliminate the 'firstof' part of the field name and keep the original
field name during the query run? At present I change the field name in design
under the table that was created.
Thanks for your help.
 
No guarantee but you can try the following.

Field: FieldName: FieldName
Table: TableName
Total: First

In an SQL statement that would look like
SELECT First([TableName].[FieldName]) as FieldName
, TableName.FieldNameAA
FROM SomeTable
GROUP BY TableName.FieldNameAA

In Access 2003 (and probably earlier versions) this works as long as you
fully designate the table and field names.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top