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) & "...