If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
access 2007 use the old query builder format
Is it possible to use the query wizard builder format to edit existing
queries in stead of the SQL format, if so how is it enabled |
#2
|
|||
|
|||
access 2007 use the old query builder format
Granpa _rb wrote:
Is it possible to use the query wizard builder format to edit existing queries in stead of the SQL format, if so how is it enabled The only thing that would prevent it from being used is if your sql included syntax that can't be rendered in the design grid. Some examples of these a - union queries - non-equi-joins (, , =, =, LIKE) - joins in which functions need to be used to make the join work (tbl1 join tbl2 on tbl1.field1=CInt(tbl2.Field1) - pass-through queries Otherwise, there should be nothing to prevent you from switching to Design View from SQL View, unless there is something of which I am unaware in A2007 (I don't have that installed). -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" |
Thread Tools | |
Display Modes | |
|
|