Results 1 to 10 of 10

Thread: "non-printing"

  1. #1
    Join Date
    Apr 2008
    Posts
    40

    Unanswered: "non-printing"

    does anyone know how tohave fields in a query that you will use to sort values but assign those fields as 'non-printing'? I want to create TSV files from a query using theose values for sorting but I don't want to see their actual values....

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Turn of the tick in the Show box.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Apr 2008
    Posts
    40
    where is this 'show' you speak of - I think I have looked everywhere, and even in search...

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It's in the Design View of any Query.
    Attached Thumbnails Attached Thumbnails sshot.jpg  
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you are using plain vanilla SQL in place of the query desginer then
    Code:
    select my, column, list from mytable
    order by acolumnnotinlistabove.
    eg
    Code:
    select EmpID, FirstName, LastName from EmpTable
    where EmpStatus="Current"
    order by DoB, DateJoined, LastName, FirstName
    there is no need for a column to appear in the select if you don't need it.

    there is virtually never a good reason to use
    Code:
    select * from mytable
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Apr 2008
    Posts
    40
    but if I turn off "show" how will I sort by those values? I don't have access in front of me so I haven't actually tried yet...

    as for the plain ol' SQL solution - i have no idea what you are offering up...

    thanks

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    just above the 'show' checkbox is a cell titled 'sort'.... gwan have a guess at what that does.

    the query designer supposedly makes it easier for people to write SQL. if you select the SQL view (leftmost button on the toolstrip) you will see what the query designer content looks like win SQL.

    SQL is a psuedo English language method of extracting and manipulating data
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Apr 2008
    Posts
    40
    ok, got it sorted out, thanks. is there a way to keep the design view while looking at the records? or to toggle between a number of different fields that are not shown but are being used for sorting?

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    In a query? No.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  10. #10
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by oompa_l
    ok, got it sorted out, thanks. is there a way to keep the design view while looking at the records? or to toggle between a number of different fields that are not shown but are being used for sorting?
    why would you want to?
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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