To have the computer calculate the age of a patient and be able to display it in a report you have to edit the report or form query, Open the report editor for the form or report in question 1) Go to the Data Tab 2) Select the Patient Query ( or query that contains the Patient information 3) Select the edit button to edit the query The Query editor will open and you should see a list of Patient fields that is selected for the report. In the list of fields insert a line and enter :
F_AgeinYearsToday(Patients.Birthdate) as Age,
This line will convert the birthdate to an age. Save the query by clicking on the OK button and then click on the Field Alias button ( item 4 above) . This will open the Edit Aliases screen. Click on the Update button and if you see a list, like above, you have not made any typos in the Query Editor. If the list is blank you have a typo. Go and fix the query. If everything is OK ( you see a list of fields after pressing the update button) you can get out of this screen and you should see in the list of field at the right of the Report screen a new field called "Age". Select and drag it to where you want it on the report of fo How to use the P_NEXT_VISIT_DATE rm.
