Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Make table queries
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Make table queries
Resolved · Low Priority · Version 2003
Reply
Make table queries
If I made a make table query and a form to run that query, and I wanted to run that query several times a year but I didnt want to re-write existing tables, how would I do that?For upcoming training course dates see: Pricing & availability
RE: Make table queries
Thank you for your questionAfter some consideration it seems the only way to do this would be to write some VBA code that would prompt the user to enter a table name and would then insert that name into the queries SQL and then run the query.
An example of the code required is as follows
Sub MakeTable()
Dim strTable As String
Dim strSQL As String
strTable = InputBox("Enter table name")
strSQL = "SELECT Employees.Company, Employees.[Last Name], Employees.[First Name] INTO" & """strtable""" & "FROM Employees;"
DoCmd.Run strSQL
End SubHowever I suggest that you might find things easier if you use an append query to send all the data to the same table. You can then run searches on that table using date ranges
Regards
Stephen
|
 |
|
» Forum post: Tables in Excel |
Is there a formula that i can use in an excel spreadsheet that will add a sum to a total creating a new total, which when you add a new sum, will add to the new total creating the next new total? As an example, if you are working out expenses on a monthly..
