Sub-summary

[awan]

HI,

I am trying to creat a Sub-summary field for sale tax, so the list has to be sorted by counties. I used the counties as a break field in Sub-summary layout, but i couldn't get it to work. Can a break field be a "pop up list"? That's the only thing I can think of.

Thanks.

[danjacoby]

If you have to figure sales tax in each record, a sub-summary ain't the way to do it.

First, create a new file with two fields, "County" and "TaxRate".

Now create a relationship from the main file, based on the respective "County" fields.

Now have the "SalesTax" field reflect the related tax rate.