Saving a table with an Auto Name (concatenation)

[TallMan]

Good Afternoon,

I am trying to find some code that when I run a "make table" query it knows to save the table as "weekly Trail Audit " with todays date.

I am thinking it would look something like this.

"Weekly Trail Audit" & Format(now, 'mm/dd/yyyy')

Not sure where I would put this or if it is even possible.

Thanks for any information you can provide.

Tallman.

 

[boblarson]

Actually, you should not store it as a separate table. All you need is a query to get the information for the period you, or your users, select from a form. At least that is what I would do.

 

[TallMan]

Bob,

I am not sure I fully understand. Do you have any examples I can look at?