access 2007 use the old query builder format

  • Thread starter Thread starter Granpa _rb
  • Start date Start date
G

Granpa _rb

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
 
Granpa said:
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
Click to expand...

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
are:
- 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).
 
Back
Top