Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: gibbolster
- Order by date
-
How to create table in SQL with current date in table name.
Thanks rac2, but I may have not stated the problem correctly or you may be overthinking it. Isn't there a way to SELECT a group of records from a table and INTO them into a new table that has a name made up of a constant plus the date of whenever the query was run? For example if I ran it...- gibbolster
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How to create table in SQL with current date in table name.
I'd like to make a copy of a table each time someone opens it(once a day). I'd like to name the new table tblProgress plus that days date. Ex; tblProgress112101 for today. SELECT [progress report].* INTO ????????? Any ideas? Thanks.- gibbolster
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
