Results 1 to 6 of 6
  1. #1
    jemelton is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    3

    Filtering/sorting data

    I have a HUGE access file with names, addresses and types of business in the spreadsheet.

    Here is the trouble (if I can explain it) The name address and other info is in row 1..........the type of business is in row 2 (corresponding to the name and address in row 1) I want to sort by state and business type.....for example I want all "A" type businesses in Indiana. Since they name and address are in the same row I can do that fine. But I have no idea what type of business it is because it sorts those alphabetically by themselves.

    The only thing that the 2 rows have in common is that there is the same number in field 1 for the name address AND business type. Here is an example of what I'm talking about:




    0000000023 John's Diner Anytown, CA USA 555-555-5555
    0000000023 restaurant


    How do I filter or sort these so I can sort and get the state and business type in the same place.

    I'm very new to access so if somebody could help me and tell me how to filter or sort I would be VERY appreciative!!!

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Before we begin, I am yet to come across any Access file (database) that has a spreadsheet in it, so I have no Idea how you pulled that off. I get the feeling you're using Access as if its Excel on steroids. It's not. What you have is a Table, not a Spreadsheet, two VASTLY different things.
    How are they broken down by fieldnames (columns)? Is it just two columns, one with the ID and the other with data? How you answer that will help get us to the solution. Your end-goal will be to have a table that is a bit easier to query (search) through to find the info you need.

  3. #3
    jemelton is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    3
    Yes, it is a table, sorry I'm a newby....but I would open it in Excel but it's too big of a file..Here is a screenshot of what I've got... http://www.flickr.com/photos/87604297@N00/4685506343/
    Last edited by jemelton; 06-09-2010 at 01:14 PM. Reason: pic did not post

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    First off, I would go ahead and name those fields something relevant (design view). Second, I believe you will need a cross-tab query to move the second row to the first.
    http://www.databasedev.co.uk/crosstab_queries.html

  5. #5
    jemelton is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    3
    Wow, that just got really complicated.....lol

  6. #6
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    well, you can always export to Excel, move the second row to the first one, and import back into Access. But I think the query (and if you'll be using Access you should know how to do one) will be faster for as much data as it looks like you have.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Filtering a Report
    By musicalogist in forum Reports
    Replies: 12
    Last Post: 04-29-2010, 08:36 PM
  2. Filtering data
    By billybong in forum Access
    Replies: 1
    Last Post: 11-07-2009, 12:20 PM
  3. Sorting data in ADO Recordset
    By martinjamesward in forum Programming
    Replies: 1
    Last Post: 08-28-2009, 05:38 AM
  4. Filtering my report
    By ldarley in forum Reports
    Replies: 1
    Last Post: 09-05-2008, 09:14 AM
  5. Sorting data in a report
    By rjsiler in forum Reports
    Replies: 1
    Last Post: 08-04-2008, 01:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums