Purchase Order Numbers - Summarizing

[Therber]

This is a quick question for those who have developed a vendor ordering system for a business. I have a line items file and with each item a purchase order field. The p.o. number appears in this field when the item has been ordered by the business. So many items can contain the same p.o. number. I'm trying to find a method to view the p.o. numbers in a summarized format where each p.o. number appears only once (one p.o. per line).

I'll keep searching the message boards, but thought I'd ask.

Thanks

[aaa]

Helo, Therber!

1. You can export your table with summary option by p.o. number then look result in new file.

2. You can create summary layout, but this layout you can see in preview mod.

[ZuperZZ]

Hi,

In your items file,

1. create a new layout

** Replacing the body part with a sub-summary part

2. double click the body part and select "sub-summary when sorted by", sorted by p.o.

3. place the fields you want

4. make the sort

5. enter preview mode

That should work.

ZuperZZ

[Therber]

AhHa! I was messing up on the sort. I also needed to do a find to remove blank p.o. numbers. Thanks!