How do you summarize a table without creating new field names?

[JWJ]

There are occassions when it is desireable to summarize common records into a summary table.&nbsp;&nbsp;Everytime I try it the fields that are summarized are renamed in the summary table as &quot;SUMOF &lt;FIELD NAME&gt;. Anyone have any answers or work arounds.&nbsp;&nbsp;I have several but am not satisifed with them.&nbsp;&nbsp;<br><br>Thank you.<br><br>JWJ<br><br><A HREF="mailto:JWJJFJ@CS.com">JWJJFJ@CS.com</A><br><br>&nbsp;

 

[Chopper]

JWJ,<br><br>I am going to assume you are using a make-table query, or showing a form in datasheet view that uses a select query as its data source.&nbsp;&nbsp;<br><br>What I typically do in this situation, is 'rename' the field being summed in the query with its own name.&nbsp;&nbsp;i.e.&nbsp;&nbsp;if field: Amount is being summed, I will use the following on the field row:&nbsp;&nbsp;Amount: [Amount]&nbsp;&nbsp;By doing this, the field Amount is named: Amount when it is summed.&nbsp;&nbsp;The same hold true when using: Count, Max, Min, and several others.<br><br>I am sure some others in this group have some fantastic suggestions as well.&nbsp;&nbsp; <p>-Chopper<br><a href=mailto: > </a><br><a href= > </a><br>