Counting Entries

[DanG]

Hi,
I have a form for data entry that consist of a main form and a subform.
The main form will contain all client info and a drop down field to indicate status...Approved, Pending and Complete.
The detail area captures the details of the pending status which is broken down by pending status number...1 = For Review, 2 = More Info Needed, 3 = Signature Required etc.
What I want to do is show all clients that are "Pending" (as indicated in the main form) and show only their most current detail status. In the end I would like a count of all clients in in pending status (main form) that are currently in detail status 1 (1 = Reviw) so I can.
The problem I have is all clients have had at one time or the other a detail status 1...so all the clients are counted.

I hope I gave enough info. And by the way I do not know SQL/VBA so the simpler the better.

Thanks in advance for the help.
Dan

 

[Georgina]

Hi Dan

Do you have a date field or autonumber on your subform datasource - you could use the max / min function in queries in order to find the latest status for the record?

Georgina