Hi



I am managing our childcare centre's waitlist. All of the children are on the main list regardless of when they require care. What I need to do is to create a query where I can look at all the families that require care for a certain in order of their application date. I have all this information already in one table. I just need to know how to break it down in to separate years.

If anyone could help me it would be greatly appreciated.