Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2012
    Posts
    4

    Unanswered: Can I save layout in Acces SQL view?

    For instance, when I type in and save the next in SQL view;

    SELECT
    LTRIM(RTRIM([firstname]) &
    RTRIM(" " & LTRIM([lastname]))) AS name,
    address,
    city,
    state
    FROM customers

    When I close the query and open it again in SQL view it will show up like this;

    SELECT LTRIM(RTRIM([firstname]) & RTRIM(" " & LTRIM([lastname]))) AS name, address, city, state
    FROM customers


    Is there a way I can save the first layout?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    As far as I know, you can't. The query builder rearranges the SQL expression of a query according to its own rules. Sometimes the text remains unchanged and sometimes not.
    Have a nice day!

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Just out of curiosity, why would you need to?

    Linq :0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Jul 2012
    Posts
    4
    It would improve readability. I want to re-use these query's but I might have to alter them slightly. And I would like to easily see what I thought up previously.
    Strange, readability seems pretty essential to me. I might get used to what Access shows me. Thanks for the replies, I can now stop searching for any options in this area

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •