saving with unique name

[Martin Watts]

This must have been asked before but I can't find anything.

I have a database from which users can print and save (as an rtf file) a
quarterly report. What I would like to do is ensure that when a report is
saved it is given a unique name so that it does not save over reports for
previous quarters with the same name and in the same location. Perhaps a
suffix/prefix could be added to the file name such as the quarter end date
which I have put on the report as a calculated control? How would the
experts do it?

TIA

Martin Watts

 

[Allen Browne]

How about the file name:
Format(Now(), "yyyymmdd\-hhnnss") & ".rtf"