asked on

Make table query question

Is there any way to have make table query create a different than the one it is pulling data from? Or create a second field and move the data to it.?

archery

Yes definitely. You can run a make table query pulling data from one, two or more tables (and only putting into the resultant table the fields that you require from each table.
You can also create an extra field into the resultant table (within the one query) field by supplying your OWN data (expression), but this would fill every field in the resultant trable with the same value
(e.g. in the "field" row of your query grid - Salutation:"Hello". This would create a field called "Salutation" in your output table and fill it with the word "Hello")

HTH

KenAdney

Here's an SQL view of it (if I understood the questions):

SELECT clients.key, clients.Contractor, clients.sub_contractor INTO Selected_clients_tbl
FROM clients

Which creates the "Selected_clients_tbl" table...

dspavlik

ASKER

Sorry I think I misled everyone I have a make a few make table queries that work fine. Just that later on in the process I use all the tables in a query and there are two tables that have the a field call "names". THis causes and error in Access telling me that I have 1 or more fields with the same name. Any Idea on how to get around this? Thanks...

ASKER CERTIFIED SOLUTION

archery

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cjswimmer

archery

To cjswimmer .... don't you love it when people do this ?

cjswimmer

unfortunately it's common

cjswimmer

oh, and also:

https://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=20133875