Hi All
I have a database that individual calls are logged for the building of system units.Access generates a report in RTF format which is sent by e-mail Ten users use this database to log these builds. The problem I have is that is if two users are using the database at the same time the report generates two builds on the one report.I need to be able to generated the report with only one system build. Is there any way to code the report so that it generates only one record for each report.
Thanks
Brendan Bartley

Brendan Bartley

__________________
Brendan Bartley

Need more detailed info on what your capturing in way of data and how your generating the report, it may be as simple as putting a criteria in the query the report is based off of. You can click on build in the query constructor and tell it to use a unique value from the form the user is looking at, if that makes sense.

The Details are captured on a form and through a query generates a report in RTF when the analyst clicks the send icon on the form the report is generated and automatically e-mails the details

Thanks
Brendan

Brendan Bartley