Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    1

    Adding new column to make-table query


    Hello,
    I have two questions:
    1) Adding new field to existing table that was created from make-table query: The existing table does not have column DocNo, but I just add that in a make-table query. Now I want to include the DocNo in the existing table without loosing all previous data. Please show me how to make it work

    Sample data:

    DocNo -----------ID
    85221088 042672430
    52297028 043317625
    85236121 061667436
    85239274 133203909
    85242941 134057211
    85231470 200154224
    85220968 222102790
    85238147 231395000
    85238147 231395000


    2) Second question: Each month I have to append new data into this table. I need to remove all the old DocNo. But I don't know how to do it. For example, for ID= 231395000 would have a new DocNo next month, so the current DocNo=85238147 would need to remove.

    Your input would appreciate.

    thanks,
    Last edited by dtn118; 07-07-2008 at 06:11 PM.

  2. #2
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38
    Dear dtn118,

    Your question need clarification.

    You can explain what you need to do by listing the fields of the tables and the required output table fields.

    Thanks

    Ahmed

  3. #3
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38
    Dear dtn118,

    You use make table query to select some fields and do some calculations and put the result of the query in new table when you run it ... right??

    So if you need to include extra columns already exist in source table to the output file you can open the query in design view and double click on the required field to add it to the output.

    To change the name of output file press query menu
    Choose make table qurey
    Change the table name.


    Thanks

    Ahmed

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 02-14-2007, 01:35 PM
  2. inserting values in column based another column
    By wasim_sono in forum Database Design
    Replies: 1
    Last Post: 06-27-2006, 05:23 AM
  3. 2 different fields into 1 column by query?
    By rainxking in forum Queries
    Replies: 1
    Last Post: 06-04-2006, 09:37 AM
  4. Using same query with different table
    By fashoda in forum Queries
    Replies: 1
    Last Post: 12-14-2005, 12:05 AM
  5. Replies: 1
    Last Post: 12-09-2005, 09:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums