SORTING.

  • Thread starter Thread starter Fab
  • Start date Start date
F

Fab

Hello,

I have a table with a parent child relation within the table and need to
sort with the partent record then its child records. i.e.


id parent_id
1
34 1
55 1
66 1
2
101 2
287 2
666 2


Thanks.
 
If I assume that Parent_ID is blank if the record is the parent (so you only
have two levels).

ORDER BY Val(NZ(Parent_ID,ID)), ID

That only works as long as ParentID is less than ID. So the following more
complex statement might work for you.

ORDER BY Val(NZ(Parent_ID,ID)), Parent_ID, ID
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Operation must use an updatable query 1
Row fix-up/updatable join on linked tables broken in Access 2007? 2
Sort across a table 2
Can I create DataSet in the designer and use it to parse xml file? 4
Return parent based on child 1
Can I add records in parent table during daughter table append? 6
Query showing all records from child table 5
duplicate results 4

Back
Top