Add existing table

  • Thread starter Thread starter cowichandave
  • Start date Start date
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.
 
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
 
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
 
Back
Top