I am trying to find a way to get a summary of how many projects were done this year. The way my database is set up is that for each sku there is a separate record. However eash project has several sku's with the same project number. I want a summary that will count all records that have the same project number as 1. For example:

Project # 463-01 has 4 sku's

Project # 475-01 has 10 sku's

Project # 480-01 has 2 sku's

in total there is 16 records created

what I am looking for is a summary that will let me know that 3 projects where done.

Please let me know how to solve this problem.

Thank you in advance.

A couple of ways come to mind:

1) create a layout with a header, subsummary by project# and footer. Set the subsummary part for a page break after each occurrence. Create a number global called gNumProj. Go to the subsummary layout, sort by project number, enter preview mode, go to the last page and set gNumProj to Status(Current Page Number).

2) Create a self relationship (SelfProj) with project# = project#. Create fields:

RecordNum (calculation, number) =

Status(CurrentRecordID)

FirstProjRec (calculation, number) =

(RecordNum = Min(SelfProj::RecordNum))

The line above is the calculation, no "If" is needed.

ProjCount (summary) =

Total of FirstProjRec

-bd