I'm very new to access and have a question.
I have a table where I have fields that have parents in the same table, e.g.
id name mother_id
1 a 0
2 b 1
3 c 2
4 d 1

I want to create a report where all the data is sorted in a tree structure of sorts... how do you do that?