"Best Fit" table windows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using ACC2000.

The more I think about this, the more I think it can't be done, but I'll ask
anyway.

I have a bunch of queries that need to be updated, which requires adding
another outer join. In the GUI, the tables in the query are at a "default"
height, covering the field I want to join. So, I have to drag down the table
window to uncover that field. Not a big deal, but it is tedious. Is there an
option in Access where it will automatically increase the # of fields shown
in a table to [n] for all the queries in the database?

Thanks!
-Mark
 
Switch the SQL view and insert the text. Skip the GUI.

FROM tableA INNER JOIN tableB on TableA.field = TableB.field

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
Back
Top