Rearrange Name

[CB_DFW]

I have this code that backs up a table and names it:

HH:MM:SS PM MM/DD/YYYY STRs

I would like to change it so that it saves as:

STRs MM/DD/YY HH:MM:SS PM

Now would be "STRs 12/18/08 12:29:51 PM"

DoCmd.RunSQL "SELECT STRs.* INTO [" & Format(Time, nnhh) & " " & Format(Date, mmdd) & " STRs] FROM STRs;"

Thanks so much.

 

[HiTechCoach]

try something like:

DoCmd.RunSQL "SELECT STRs.* INTO [STRs " & Format(Date, mmddyy) & " " & Format(Time, nnhh)& "] FROM STRs;"

 

[CB_DFW]

Worked perfect. Thanks a bunch.

 

[HiTechCoach]

You're welcome!

Glad I could assist.