Counting clients

[Rockape]

Hi,

Grateful for advice.

(Using MS Access 97 and 20003)

I have a database with a number of clients. I have created a form that will query the database to find me the number of clients that contain a name, eg. Smith

I get the following:-
Mr J Smith,
Mr and Mrs A Smith,
A Smith and B Smith.

I have a report that will list the transactions for each name. However I would like to warn the user that the report has found three different variations for the name searched.

I tried this at the top of the page
=[Pages] & " Variations of the name selected"

This works fine but if the number of transactions for say the first name spills over to a second page of the report, I get the problem that the report will state that - 4 variations of the name selected - appears when only three names has been found.

Is there any way around this?

Thanks

 

[Rockape]

hi Pat,

Done all that....also got a sample mdb. Woul dyou care to see and correct for me?