Instead of having subtotals in the body of your (linked) data, you can
have a separate table using SUMIF to produce the subtotals.

Hope this helps.

Pete

On Dec 11, 11:19*am, Tony wrote:
Hi.
When i link data from access 2007, i cannot use subtotals without having to
change the linked data to range. Is there a way of keaping the data linked
and have subtotals?