From a computer with MS Excel installed do this:
In the printer output dialog select to send to EXCEL.
In the Report setup window change the dates to 01/01/1900 to 12/31/2022.
This will capture all active patients in your database.
Do not change the file name. Click OK to open Excel.
Excel will open. Click the RAW tab located on the bottom of the spreadsheet.
Click the drop-down menu on the AutoSum button in Excel. Select Average. Look for the column with the age listed. Now click the first age listed and drag down to the last age listed. Click enter on your keyboard when all ages are selected.
Go back to the top of the page and the average will be displayed. 🙂
Not the easiest report but....here goes! 😊
Reports > Patients > User-Selected. Add > give it a title > OK.
Now you have to Edit Values, if you have a X in front of topic it will be on report. Click on each one with an X - uncheck Print and it will not show. If there is something you'd like extra in report , click on that topic and place a X to print.
When you select Age - you can have 2 groups listed. I would suggest you do GE (greater than and equal to & LE (less than and equal to) Such as 20 to 40, or 40 to 60. But if you want more details you would have to create more reports titled age 1-20, 21-30, 31-40, etc.. Now, you will get a report of ages and total of all in that age group....but it cannot be sent to Excel...which is probably what you wanted. Sorry this is the best I can think of.