By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,086 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,086 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.