>Yes in the detail lets say I have 3 records this is what I get
>
>Strain Quantity Location2 userid date notes
>blueberry 150 1E 100 05/12/08 blah blah
> Total 150
>
>Strain Quantity Location2 userid date notes
>blueberry 116 7A 101 05/13/08 words...
> Total 116
>
>more of the same and then a sum total at bottom.
>
>I know somehow I have done this or ???
>
>Thanks,
>
>Fred W.
Because I don't know what you want that is just a SWAG:
Add Summary band in your report and put Totals there. If you want some sub-totals you have to have a GROUP in your report. Then put sub-totals in the group footer. Neve put TOTALS in detail band.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.