Queries and my brains aint mixing

[chrisjnelson]

I have a query that works out peoples ages and wether they are current, i have another query that pigeon holes those ages into age ranges.

What i want it to do next is use this data on a form in a list format. I.e i want the form to return a list of current people broken down into their age ranges.

Is this possible?

Thank you,

 

[mkleino]

Certainly, although it sounds like what you want to make is a report, not a form...I assume you mean you just want a list for reference, that will update with the data. If so, make a report with the report wizard, and it will prompt you for how you want to categorize the data in a list, along with giving you many other options.

 

[chrisjnelson]

Thanks for the tip, but i didnt explain myself properly. Sorry!!

I need he data on a form so that i can use it as a type of register. (i.e names down the left, start time in the centre and finish time down the right side)