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

Append Crosstab Query to Existing Table 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Office365 Family + TXT or MX Domain 0
Microsoft Office Standard 2013 0
query to show where no data in a stated column 0
Outlook 2016: recent change to add account. No browse for data file. 0
Make table query: [Enter 1] AS Test 1

Top