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

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.

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