If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
queries
I am trying to create a make table query but when I click get the new query
dialog box I only have five options for queries and make table is not one of them. I am using 2003. How do I get these other queries (append, etc.)? -- Jerry Schutt |
#2
|
|||
|
|||
queries
Use one of those 5 options to create a query that returns/selects the
records you want to append to another table or make a table out of. Then, with your query in design view, select "Query" on the menu bar and change the query from a Select query to a Make-table or Append query. HTH, -- George Nicholson Remove 'Junk' from return address. "Jerry" wrote in message ... I am trying to create a make table query but when I click get the new query dialog box I only have five options for queries and make table is not one of them. I am using 2003. How do I get these other queries (append, etc.)? -- Jerry Schutt |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Sub Queries Coded for use in a main Query | PatT123 | Running & Setting Up Queries | 1 | August 24th, 2005 08:34 PM |
Combining Queries | FrankM | Running & Setting Up Queries | 2 | June 16th, 2005 01:21 PM |
Using calculated fields in multiple queries | Linguist | Running & Setting Up Queries | 6 | May 27th, 2005 02:09 PM |
Access2K append queries fail under XP Pro | [email protected] | Running & Setting Up Queries | 1 | May 25th, 2005 08:46 PM |
Bitwise And | Sam Hobbs | Running & Setting Up Queries | 44 | October 14th, 2004 04:19 AM |