I am creating a roster of members in an organization. In the report I
want to show the ages of those members 20 years or younger, but not
the ages of the older members. I have created a query that includes
the ages of all members. How do I suppress the printing of ages in
the report of those members 21 years or older?

Thanks

abbott10 (AT) comcast (DOT) net (tabbott) wrote in message news:<2a7214fc.0404251651.7d90b024 (AT) posting (DOT) google.com>...
Hello,

Perhaps you could add one more column to your query.

Example:

Under21Years: IIf([txtAgeField]<21,[txtAgeField],null)

What this is saying: If the data in txtAgeField is less
than 21, then display the age, else don't show anything.

Also, you might want to look up the IIF() function to
get a better understanding of it if you don't already.

Regards,

Ray