Unique report name?

[Homegrownandy]

Normally when making reports, Its usually related to one thing. Such as; a project; a job or an order. Now I'm making a report that really doesn't have ONE table that relates them all.



So what I would do normally is implement an "issue" system. Where by every time a report is created it adds 1 to the issue number making every report unique.

I'm wondering how to best achieve a unique report name when I cant simply increment a single record (its a very flat structure and could be any of the records).

Its just a theory question I'm after some ideas.

[CJ_London]

providing you don't want an incremental value, use the Now() function - formatted perhaps as yymmddhhmm for easy sorting

[Homegrownandy]

Shockingly obvious. Thanks!

[CJ_London]

suggest put the datetime value at the beginning of the file name - will be neater

[Homegrownandy]

for anyone attempting this.

="C:\Users\ah\Desktop\SAGE_IMPORT\" & Trim(Format(Date(),"yyyy_mm_dd")) & ".xlsx"

Backslashes in a file path will look for a new folder. formatting like this will stop that. (I've encountered this before and took me days to figure out what the problem was. Another obvious one.)