On Feb 19, 4:00*pm, Ron Rosenfeld wrote:
On Sun, 19 Feb 2012 12:38:18 -0800 (PST), gary wrote:
the total lines don't contain the key (i.e., A/N).

(See my newer post tin this group).

Since this seems to be just a minor modification of your original problem, rather than something completely different, it seems to me you will be more likely to obtain an appropriate response by asking in your original thread. *I'm not going to recreate what Don has already provided you, but it should not take much of a modification.

I ended up using the Subtotal function.