Custom Reports note field not printing & need age

[Dicounts]

I am creating a custom form for the pastor to use when he goes out on visits. I am creating this report under personal profiles, custom reports. I am grouping by family, listing each member of the family along with their first visit date, or joined date. I'd also like to print out the notes that I have created in the main database, and in the individual database. The individual notes (menotes) are printing fine. The family notes (note1) are not printing at all.

I would also like to do an age calculation for the children based on their birthdates. Is this possible?

Thank you

[Dicounts]

I went through the report setup once again, and realized my mistake. I was selecting the wrong note field. It is working now, just have to work on the alignment.

Still wondering about the age calculation.

[Zorak]

The following expression in a variable will properly calculate the age:

Code: Select all

Year(date())-Year(born)-IIF(Month(DATE()) * 32 + Day(Date()) < Month(born) * 32 + Day(born), 1, 0)

Hopefully, you don't need an explanation... I copied and pasted