Reporting with Sequential Numbers

[Emmz]

Hi,

I currently have a query/report which is e-mail to an outside user via a macro. However I now need to add a sequential number to the query for every e-mailed event, is this possible?

 

[Uncle Gizmo]

Have a look at this example on Roger Carlson's website here:

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=309

 

[Emmz]

Hi,

Sorry I don't think that I made myself clear it is actually the attachment name I wan't to change i.e. DCBnnnnnnn.txt where 'nnnnn' is a swquence number starting at 00001.