[AccessD] Average ages

This should be simple...I think I am just missing something simple (and
probably dumb).

I have a query that has the following fields:

Client Name: UCase([txtLastName] & ", " & [txtFirstName])
xAge: IIf(IsNull([datDOB]),0,Age([tblClient]![datDOB]))
kSubContID
lnkClient
CareGiver (Criteria: True)
DatEntry (Criteria: >=#04/01/04#)

The SQL looks like this:

SELECT UCase([txtLastName] & ", " & [txtFirstName]) AS [Client Name],
IIf(IsNull([datDOB]),0,Age([tblClient]![datDOB])) AS xAge,
tblSubConts.kSubContID, tblSubConts.lnkClient, tblSubConts.CareGiver,
tblClient.datEntry
FROM tblClient INNER JOIN tblSubConts ON tblClient.kClientID =
tblSubConts.lnkClient
WHERE (((tblSubConts.CareGiver)=True) AND
((tblClient.datEntry)>=#4/1/2004#))
ORDER BY UCase([txtLastName] & ", " & [txtFirstName]),
tblClient.datEntry;


How do I get an average age for all of my clients in this query? I
think I could muddle through this easier in a report or form, but I just
needed a number, and I tried using the 'Totals' section for the query
and choosing 'Avg' for the 'xAge' field. This does not seem to work
though.

John W. Clark
Computer Programmer
Niagara County
Central Data Processing