group rows in a query

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

Guest

I run a query in access 2003 and use the group by and first functions.
Everything works fine except when I create a table from this data the column
heading contains "first of' and then the name. Is there a way to eliminate
the 'first of' other than going into design for the tale and changing the
title?
Thanks for your help.
 
Did you try what I suggested in response to your earlier post. It should
work.

In the design view (query grid) you would enter
Field: FieldName: FieldName
Table: TableName
Total: First

That is type the fieldname and a colon before the field name

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


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
You could use:
IIf([fldCode]=1,"Yes",IIf([fldCode]=2,"No",Null)) in the field of the query
design grid.

Though generally, 0 should represent No/Off/False and -1 should represent
Yes/On/True
 
Sorry - put that in the wrong post.

Darren Bartrup said:
You could use:
IIf([fldCode]=1,"Yes",IIf([fldCode]=2,"No",Null)) in the field of the query
design grid.

Though generally, 0 should represent No/Off/False and -1 should represent
Yes/On/True

JH said:
I run a query in access 2003 and use the group by and first functions.
Everything works fine except when I create a table from this data the column
heading contains "first of' and then the name. Is there a way to eliminate
the 'first of' other than going into design for the tale and changing the
title?
Thanks for your help.
Click to expand...
Click to expand...
 
Back
Top