Count/Sum filter criteria

  • Thread starter Thread starter pow67
  • Start date Start date
P

pow67

[CAT] is a text field
[VERIFIED] is a date field
[Area1] is a Yes/No field
[ALD] is a Yes/No field
[FLK] is a Yes/No field

My existing query is grouped by [CAT] and provides a total count of
records for each [CAT] followed by a sum of that [CAT] for [Area1],
[ALD] and [FLK].

I would like to count only those records where [VERIFIED] is
"<Date()-360". I placed [VERIFIED] in another column and set the
criteria to "<Date()-360" but that produced a long list of separate
records for all dates verified. Suggestions appreciated.

My query design is:

Column 1: [CAT] Group By
Column 2: [CAT] Count
Column 3: [Area1] Sum
Column 4: [ALD] Sum
Column 5: [FLK] Sum

Using "count" for [Area1], [ALD] and [FLK] produced incorrect values.

Thanks in advance.

CW
 
(from your previous post) Since it is a Totals Query, the default SQL
Aggregate function is "Group By". You need to change the "Total" entry for
the [VERIFIED] Column to "Where" rather than "Group By".
 
Back
Top