SORT QUERY AND VALUE ASSIGNMENT

From: PARADISE HILLS - FLYING HIGH (anonymous_at_discussions.microsoft.com)
Date: 05/25/04

  • Next message: Vishal Parkar: "Re: SORT QUERY AND VALUE ASSIGNMENT" 
    Date: Tue, 25 May 2004 13:21:02 -0700

    I need syntax for a Microsoft Access database query. I have a table with 40,000 records. One field has directory paths with backslashes for each subfolder. Let's call that field 'backslashes'. Some records go 9 (nine) levels deep. I have another field, let's call it 'qtybackslashes'. I need a query to sort records by the number of backslashes in each records' 'backslash' field, and then assign a value for each record in it's 'qtybackslask' field. The value should be 1 (one) if there is 1 backslash in the 'backslash' directory, path. It should assign a value of 2 if there are 2 backslashes, 3 if there are 3, and so on. I can build the query using either Access database syntax or SQL syntax. What would the syntax for the queary be?

  • Next message: Vishal Parkar: "Re: SORT QUERY AND VALUE ASSIGNMENT"