Summary report from script

[Chuck J]

I have a request to creat a report in an existing database that will find

1. New records entered in the last week using the date field "Date Entered"

2. Jobs completed in the last week using the date field "Date Finished"

3. Jobs in progress (the total of "Date Entered" minus "Date finished"

The problem I am having is getting all this information on one layout.

I am sure FileMaker is capable of doing this, I'm not sure I can handle it without a bit of help.

Thanks

[Slobey]

I assume there is no problem finding the jobs. Just diplaying them.

What is it that you want to display? Just a summary of the number of jobs in each category? The individual records of each job? If you could explain a little further.