FPSQL

[Walter D Vaughan Jr]

The following assumes that Doc_code is in the patient _events table.
Also I am not sure about the total column. What you are doing is
adding the count of the number of rows of patient events where you have
per Doc_code  as well as the subtotal of field 10 per Doc_code. 
If that is correct then the following works. 

Select Doc_code,   count(*)+sum(@10) 'total'
>From 	 patient_events
Where	doc_code >= 1000 and doc_code < 9990    
group by DOC_code

> -----Original Message-----
> From: Richard Kreiss [mailto:rkreiss at verizon.net]
> > > Is there a way to get a total for each Code or name?  i.e. Gorman 141