Need Query by Month when date written as **/**/2004

[bmoos1]

I need to make a Report of all people starting in 2004 by "Date
Requested". Dates are entered as mm/dd/yyyy. I have a query that has
all the people that started in 2004, but there are numerous dates/days
per month. I need to combine in my Report to show:

Month: 01
# of starters 14
Type: BD 7 $1020
CC 7 $925

This is what the query looks like so far

Date Requested Type CountOfType SumOfMonthly SumOfBi
1/4/2004 BD 6 720 0
1/4/2004 CC 7 925 45
1/5/2004 BD 1 300 0
Thanks so much for your help

Grammie

[Bob Quintal]

"bm****@yahoo.com" <bm****@yahoo.com> wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:

I need to make a Report of all people starting in 2004 by
"Date Requested". Dates are entered as mm/dd/yyyy. I have a
query that has all the people that started in 2004, but there
are numerous dates/days per month. I need to combine in my
Report to show:

Month: 01
# of starters 14
Type: BD 7 $1020
CC 7 $925

This is what the query looks like so far

Date Requested Type CountOfType SumOfMonthly
SumOfBi 1/4/2004 BD 6 720 0
1/4/2004 CC 7 925 45
1/5/2004 BD 1 300 0
Thanks so much for your help

Grammie

Do a little reading in the help files for the year() and month()
functions. Use them in the sorting and grouping popup of your
report.

--
Bob Quintal

PA is y I've altered my email address.