Count how many records in subform that meet criteria

  • Thread starter Thread starter Jane higgs via AccessMonster.com
  • Start date Start date
J

Jane higgs via AccessMonster.com

I have a main form and a subform. I would like to count how many records in
the subform meet this criteria.

If DateSubmit is between 4/1/2005 and 6/30/2005, count how many records.

The field on the mainform is "2Q05".

Thanks in advance.
 
Build a query like --
SELECT [SubForm].ChildField, Count([SubForm].[Items]) AS [CountOfItems]
FROM [SubForm]
GROUP BY [SubForm].ChildField;

Join this query in your main form query.
 
Back
Top