Response to earlier post

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

in an earlier post I had the question of
----------------------------------------------------------
I have a table that contains a date field. The date is
formated as such (mm/dd/yy) Is there a query that I
could create that would COUNT the total number for each
month? If so could you please point me in the right
direction?
----------------------------------------------------------

Thanks for your reply but I forgot to metion how I wanted
the output. I wanted the output to look like a crosstab
query. So it would look like this:

01/03 02/03 03/03
(# of dates) 3 2 6

Can this be done? If so can anyone help me?


Thanks again,
Chad
 
I don't see any row headings so you can fake one:
Total:"Total"
Use a column heading of
ColHead:Format([YourDateField],"mm/yy")
Set the value to:
Count([YourDateField])
 
Back
Top