I have a table with a list of names in it.
I then have a query that links by name and is used for a report.
How do I write codes to link the query to the 1st person then output the report, then link to the second person and output the report...and so on.eg
Table 1
-------
Mr X
Mrs Y
Mr Z
I want to output a standard report one for each person, but this list may grow or shrink so I cant use exact names in the code ??
Thanks
If this doesn't make sense please let me know.
Thanks
Jamie
I then have a query that links by name and is used for a report.
How do I write codes to link the query to the 1st person then output the report, then link to the second person and output the report...and so on.eg
Table 1
-------
Mr X
Mrs Y
Mr Z
I want to output a standard report one for each person, but this list may grow or shrink so I cant use exact names in the code ??
Thanks
If this doesn't make sense please let me know.
Thanks
Jamie