Hi, I created a database table tracking patient intakes and other information. Now I need to create a trend report in order to present this data. Is there a way that I can do that without manually going down the entire table? Please someone say there's a way... Thanks.

Generally you use a group by/totaling query to get stats.

Um ... what trend do you need?

Please example in detail what you need.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

I need to show the frequency of certain areas of a screening database. I need to track how many patients wound up signing on for regular sessions and then compare that with the time of year that they began treatment, age groups, locations, therapy types, and if they did not begin treatment I need to track the reasons why, the therapists they were assigned to, and the referral types.

The database table I have already has all of that info in it but I don't know how to pull it into a more readable format.

From what you have described I would expect that you have multiple tables to properly store the data in a normalized structure.

I usually create a separate report for each trend/statistic. To get then to print on the same report I insert each report as a sub report.

I would start by making a query to select the how many patients wound up signing on for regular sessions.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015