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?