Hi. I've a question regarding doing a search on a GetSummary calculation field.

I have fields as follows...

EmpId(Number)

Status(Text)

Date(Date)

Count Of Student ID(Summary)

No.Occurrences(Calculation = GetSummary(Count Of Student ID, Student ID)

I need to be able to do a search for eg.

Status = "Present"

in Date Range 1/1/2004...31/12/2004

with no. occurrences per employee = 4

I'm having major difficulty doing the find for the no.employees. Is it possible to do this using a calculation field which uses getSummary?

If I do the search first of all for the required Status and Date and then subsequently I sort by Student ID, then the No. occurrences shows up correctly but I can't seem to search directly for the no. occurrences.

Anyone got an idea of how I might do this?

I dont tried it, but If this didnt work try to do like this:

After finding and sorting:

Loop

If(occurrenc<>4)

Omit record

Elseif

Goto record next exit after last

Endloop

If count of your records not is so match this will hel[ you.