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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iif then statement needed for Access 2007 please 5
Query Builder tool 2
Expression Builder and Update Query 1
filter last five rows in a table using query builder in MS access 1
Expression builder trouble 1
Expression Builder help. 8
Modifying subform's underlying SQL statement 2
Counting records in a query 9

Back
Top