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

Hi,

Try using:

=Count(Fieldname) & " Variations...

Just my 2 cents...

Hi,

Where should I put this?
and , should I write that only?

thanks

I think what DB meant is for you to try replacing



with

Hi,


Glen is correct. That's what I meant to say. If you are not sure what is the name of your field, then try typing this in exactly:

=Count(*) & " Variations of the name selected"

Just my 2 cents...