Results 1 to 12 of 12
  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Sort (Access '07)

    I am trying to learn Access so I thought this would also be a good opportunity to list all of the DVD's that we have.
    I have 7 columns, not including the ID Column. 2 of the columns which I have named "Title" and "Series" I cannot sort. All of the rest I can.
    I know this is not a lot of information, so ask a way and I shall answer what you might need to know to help me figure this out.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sort (Access '07)

    John

    When you say I cannot sort, is there something preventing you doing it?. Have you tried making a query from the table and doing a sort on that?
    Jerry

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Sort (Access '07)

    Jerry,
    when I highlite the title of the colum I want to sort the "sort" functions are all greyed out. Including when I right click on that column. I am able to do a query, but being that I am new to this I am not really sure what I am looking at. It appears that a query brings up everything? but puts what I want first?
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sort (Access '07)

    What is the data type of the fields on which you can't sort?

  5. #5
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Sort (Access '07)

    All are Text
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sort (Access '07)

    Hmm - you should be able to sort on text fields in a table. Could you post a stripped down copy of your database in Access 2000 or Access 97 format? See <post#=401925>post 401925</post#> for instructions. (Not sure if and how the instructions should be modified for Access 2007)

  7. #7
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Sort (Access '07)

    Although it shows that I can save it, it wont let me. See attachment Edit: I tried to save it again after deleting the multi valued fields. Still a no go
    Attached Images Attached Images
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sort (Access '07)

    Do the fields you cannot sort on happen to be multivalued? I don't have Access 2007, but I wouldn't be surprised if it wouldn't be possible to sort on multivalued fields.

  9. #9
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Sort (Access '07)

    No, none of the fields that I want to sort are multi valued. Those sort just fine. I'm thinking its time to hit Barnes and Noble.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sort (Access '07)

    Hopefully someone who has Access 2007 will come up with a suggestion.

    In the meantime, have you tried a query, as suggested by Jerry?
    - Create a new query in design view.
    - Add the table in question.
    - Add the first item from the field list (tablename.*) to the query grid.
    - Add the field you want to sort on to the query grid.
    - Clear the Show check box for this column.
    - Select Ascending or Descending as sort order for this column, as desired.
    - Select View | Datasheet to test whether the query works.

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sort (Access '07)

    Before trying to save the database as 2000 format, did you convert the ANSI 92 SQL? When you say the sort is grayed out, do you mean that it just *looks* grayed out or that you tried it and it was unavailable? One of the somewhat irritating aspects of 2007 is that the menus often appear grayed out even when active. If all the fields in the table are simple text fields, you should have no problems with any of them. The message you posted indicates something peculiar to 2oo7 is in the table, and simple text fields don't fall into that category.

    Can you post the database in 2007 format? If so, I'll open it and take a look. If it is too big to post, create a new empty 2007 format database and import only the table in question into it.
    Charlotte

  12. #12
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Sort (Access '07)

    Q: Before trying to save the database as 2000 format, did you convert the ANSI 92 SQL?
    A: No -
    No the buttons were 100% non functional. Unfortunetly I can't send even a portion of the database. I deleted it and decided to start over.
    Before I do though I have some reading to do starting with "Step by Step Office Access 2007" by Steve Lambert, M. Dow Lambert III, and Joan Preppernau.
    I am sure that I will have more questions as I go.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

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