Make Table

=?Utf-8?B?QW5keQ==?=

Guest

Posts: n/a

18th Nov 2003

I have set up a Select Query to display a number of Order related fields from various tables. When I run the select query the customer names are displayed from a linked Customers table. When I change this query to a Make Table query the new table contains the the primary key from the customers table instead of the name.

How do i get the query to create the new table with the customer names not customer ID?

Thanks

« Hide Columns in Query Design | Using update query to post results of a calculated field »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how make table name in make-table query an input?	Ian Elliott	Microsoft Access Queries	3	27th Aug 2009 04:41 AM
Is it Possible to make a table from a query without a Make Table Q	=?Utf-8?B?V2lsZGx5SGFycnk=?=	Microsoft Access	9	6th Nov 2007 07:44 AM
Make Table Query-Running a make table query before you open a for	=?Utf-8?B?dGtpcmNob2ZmMTU=?=	Microsoft Access Macros	4	13th Apr 2007 11:50 PM
To have month and year as part of the table name in CREATE TABLE or MAKE TABLE Query	ichew@scs.com.sg	Microsoft Access Getting Started	1	18th Apr 2006 06:38 AM
Create Table Primary Key after Make Table Query And Update Table	=?Utf-8?B?Uk5VU1pAT0tEUFM=?=	Microsoft Access Queries	1	3rd May 2005 08:07 PM