Setup of Design View

  • Thread starter Thread starter briank
  • Start date Start date
B

briank

I have inherited an Access 2007 db. Upon reviewing the selection of queries
I see that the previous developer preferred to view the query in much
different view than I am used to. In design view the columns and rows, for
lack of a better term, appear to be transposed. Columns resemble the
following:
Column Alias Table Output Sort_Type Sort_Order Criteria

How do I get this back to the normal view (normal being what is shown in
most books and web sites)?
 
Perhaps you want the SQL view. That shows the actual SQL statement.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
The actual SQL statement is certainly one way to go but since I am more
familiar with the UI I was hoping to utilize this approach. I have just
found out that my file is an ADP (which I am currently researching on what
this actually means) and was wondering is this bares some importance to my
earlier question.
 

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

Access Automatically Moving Criteria Columns to End of Query (DesignView) 3
SQL View 5
Design View Criteria question 5
Function of colon between table names when query in design view 4
Access Query error locks design view 1
Cannot see fields in query design view on laptop; Access 2003 1
ERROR 3125 when trying to enter design view of a query in 2007 6
EDIT SQL without going into design view first? 2

Back
Top