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
 
Top