Crosstab Query not enough??

  • Thread starter Thread starter Marcus D
  • Start date Start date
M

Marcus D

I'm trying to get a crosstab query to count the number of
records the happen during different time spans on
different days of the week (eg - On Sundays between 0700
and 1700 how many records exist, and between 1700-1900 and
between 1900 and 0000). Unfortunately I keep returning
ALL the records when I just want a count...
 
Marcus,

Your value field's Totals setting should be Count isnstead of Group By.

HTH,
Nikos
 
Back
Top