Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003

    Question Unanswered: Create a table using query

    Is there any way that I can create a table base on a query?

    Or is there any way to fill in an pre-define empty table with data I got from running the query?

    Thanks a lot for helping!!!!

  2. #2
    Join Date
    Aug 2002
    You can specify what type of a query to create up on the toolbar... (it is the button to the left of the red exclamation point button)... select the Make-Table type and you'll be prompted for the table name. Include the data fields you need in the query, and a table will be created for you with those when you run it.

  3. #3
    Join Date
    Apr 2002
    In addition to your second question, if you use the "Append" query type, you will be able to fill an already existing empty table with the records you selected.
    This sometimes works better because when using MakeTable you have no control over the field-types in your result table. Access decides for you, and you may not always like the result.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts