Formula for Report

  • Thread starter Thread starter Dominique Schwartz
  • Start date Start date
D

Dominique Schwartz

I have a report I'm compiling and one of the calculations
I need is for total number of children from a specific
community per month and year to date. What I'm wondering
is can I use =DCount
("Address","qryDomesticViolence","Address='rural'") AND
=DCount
("NumberOfChildrenAcommpanying","qryDomesticViolence") to
get the results I need?
Or is there some other method of doing this?
As well I have a field on the report that requires I get
the count per month of children from the query, the
problem I'm having is that the ages are written as 0-5,
etc and there are entries for up to 7 children the fields
are named AgeChild(1) etc...is there some way to calculate
the total number of children for each age group from this
table?
Thanks!
 
Could you please supply a sample of your data and what you expect to display
on your report?
You mention "per month" and "year to date" but you don't provide a date
field name. Also, it looks like your table might not be normalized. Do you
have multiple repeating fields for "AgeChild"?
 
Back
Top