Creating monthly totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many dates that range from jan 04 to july 0f 05 and I am trying to
count the dates for each month in order to come up with the total amount of
dates in my table for each month. I tried using the count filter and using
an example....( Like "1/*/2004") in order to try to count all the dates in
jan. This did not work. Is there a way to be able to count all the dates in
each month and somehow populate the data in a table or query? Thanks
 
Dates are stored as 8 byte floating point numbers (the integer portion
represents the date as the number of days relative to 30 Dec, 1899, and the
decimal portion represents the time as a fraction of a day), therefore
wildcards don't work.

You can add a computed field to the query that returns the month and year
using Format(MyDateField, "yyyymm"), or you can add two computed fields, one
each for month and year (Month(MyDateField) and Year(MyDateField), for
instance)
 
Back
Top