Add existing table

C

cowichandave

I have an existing query and would like to expand it to include data from
another table not included in this query. I can add it to the existing
relationships. I cannot see where you can add an existing table onlt that you
can create a rable.
 
T

Tom van Stiphout

On Sat, 5 Dec 2009 16:46:01 -0800, cowichandave

Right-click on the query design surface and select "show table".

-Tom.
Microsoft Access MVP
 
C

cowichandave

It only shows the 3 tables that are in the query. I want to add a 4th table
 
R

Rob Parker

Right-click in a blank area in the top section of the query design grid
(where the three tables are shown), and from the pop-up menu, select "Show
Table ...". Select the additional table (or query) in the dialog box that
appears. Then join appropriately to another table in the query (may not be
necessary if there is an existing relationship).

HTH,

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make table query: [Enter 1] AS Test 1
Query to duplicate a record with one field updated 0
Delete whole table with SQL and ADO 1
update query 2
Adding New Record to a linked table from Query 1
Need to upate union query statement every month 1
Append Query 2
an ab-normal bite in the rear end ? 6

Top