Display Multiple finds

[SamanthaB]

Hi Guys,

I'm not sure if this is possible and I hope I explain this correctly,

I have a database of photos, each record has a name eg. 'Riverside' and there can be hundreds of records with the same name.

Within each record is a field called 'SRPath' that can contain one of three variables

photo/CD/ or photo/Class/ or photo/Classic/

What I would like to do is first isolate all the records with the name 'Riverside' which is easy, but I would like to then display

the total number of records within that found set that contain the three variables in the 'SRPath' field...

eg.

Riverside

Total CD = 236

Total Class = 589

Total Classic = 895

It would also be nice if these totals continually changed depending on the initial search.

Any pointers would be appreciated.

Thanks

Samantha

[Vaughan]

If this is for reporting (ie, generating statistics rather than finding a set of records) then a summary report will do what you want.