NEED ONLY SPECIFIC CALCULATED AGES IN REPORT

[joanl]

I've checked the searches for my particular dilemma, but can only find how to calculate ages. One of my fields in the table is the DOB (date of birth). My report has an unbound textbox called CurrentAge with this code in the control source:

 =IIf(Not IsNull([DOB]),Fix((Now()-[DOB])/365.25))

All the ages display just fine in the report. But in my report, I need to display people aged 18 and older. I've tried placing the [CurrentAge] >=18 parameter in the filter property on the report, but doesn't work. Would code work better? Any suggestions or help is really appreciated.

 

[CosmoKramer]

Hopefully your report's record source is a query. If so, add a calculated field to the query for the age and set your criteria to >=18

HTH

 

[MichaelRed]

BDay18 = DateAdd("yyyy", 18, #8/21/92#)
? BDay18 < Now
MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[joanl]

Thanks for everyone's input. I used the query method and it works like a charm.