report from subform

[sadie]

I have a form and in it is a sub form called event where I can keep entering new things that happen to the client i.e. admission to a residential placement, withdrawn from placement etc.)
When I enter the info the most recent event is last in the list. I have made a query and report and the most recent event is at the top...can this be changed

 

[Hayley Baxter]

You can go into the properties of your report, sorting and grouping and sort by the order you wish the items to be displayed. You can also perform a sort in the query.

 

[sadie]

Thanks...I don't know why I didn't think of that