legorli

Hi, Actually, it is the date that will be entered into the fields. I'm sorry, guess I still wasn't too clear. Because I've been looking at it for such a long time, I just seem to assume that other people will know what I'm talking about. But I figured out a solution. It ain't pretty but it works. I just made calculation fields from an If statement (so it would have a value in it if it's during a specified period) and then counted those fields. That probably doesn't make much sense but I'm just happy I got it working. There's probaby a better way of doing it but this'll do for now. Thanks Ugo!! L

Okay... I'll see if I can elaborate. I didn't create it but it's a fairly simple db. It is just a single database with no relationships to other tables or anything. It just has a whole bunch of fields with information about the requests. As I mentioned before, the key fields being when a request was received, initiated, and completed. The person who processes the request is entered per record via radio buttons. Each record is identified by a field: "record number" which is an automatically entered serial number. What I can do now is specify a date period (ie. a specific month) in a script step and then if I enter that date in the received field, I can count how many were received in that period, and how many out of those have been initiated or completed in that period. I've done that using simple calculation fields of count(initiated) and count(completed) and grouping the results according to the employee. Is this the right track? Or am I way off? I'm having trouble figuring out how to count the requests that have been initiated or completed in this month that were received last month. Any help would be greatly appreciated. Thanks! L

To clarify... I also have multiple people processing these requests so it also needs to be grouped by person as well (done by a subsummary rpt right now).

Hi, I have a database that has 3 different date fields: received, initiated, and completed. Is there a way I can produce a report which has a count of all the requests received during a specified period, all the requests initiated during that specified period, and all the requests completed in that same period? Thanks, L

OH, I see. Thank you so much!!

Hi, I'm very new to Filemaker and more used to another database program so I'm having a difficult time making things work how I want it to. The user enters in information through a form layout that had been previously created. I have created a layout/report which did work how I wanted it to. It listed an employee and a count of records related to that employee. It worked fine. My problem is that when I go into the entry form layout and perform a find, when I go to the report that I had created, it doesn't work anymore (whether it is showing only the found set or all records). Only the grand total shows up. The subtotals for the subsummaries (grouped by employee) don't appear. However, a couple times, I had gone through and created another report with the exact same info, and the reports work again (including the one that refused to work earlier). Does anyone have any idea why this is happening? Thanks, L