DatePart question

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

Guest

I want to use DatePart in a query to group/count the number of items received
per month for 2004. The data is in a table and daily receipts are posted by
day/date.
 
I want to use DatePart in a query to group/count the number of items received
per month for 2004. The data is in a table and daily receipts are posted by
day/date.
Click to expand...

You don't really need DataPart. There is a built in Month() function
which returns an integer month number, 1 to 12, from a date. You
should be able to create a Query; in a vacant Field cell type

RecdMonth: Month([datefield])

Change it to a Totals query; group by RecdMonth and count and/or sum
the receipts.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
PERFECT !! Thanks

John Vinson said:
I want to use DatePart in a query to group/count the number of items received
per month for 2004. The data is in a table and daily receipts are posted by
day/date.
Click to expand...

You don't really need DataPart. There is a built in Month() function
which returns an integer month number, 1 to 12, from a date. You
should be able to create a Query; in a vacant Field cell type

RecdMonth: Month([datefield])

Change it to a Totals query; group by RecdMonth and count and/or sum
the receipts.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
PERFECT !! Thanks

John Vinson said:
I want to use DatePart in a query to group/count the number of items received
per month for 2004. The data is in a table and daily receipts are posted by
day/date.
Click to expand...

You don't really need DataPart. There is a built in Month() function
which returns an integer month number, 1 to 12, from a date. You
should be able to create a Query; in a vacant Field cell type

RecdMonth: Month([datefield])

Change it to a Totals query; group by RecdMonth and count and/or sum
the receipts.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
PERFECT !! Thanks

John Vinson said:
I want to use DatePart in a query to group/count the number of items received
per month for 2004. The data is in a table and daily receipts are posted by
day/date.
Click to expand...

You don't really need DataPart. There is a built in Month() function
which returns an integer month number, 1 to 12, from a date. You
should be able to create a Query; in a vacant Field cell type

RecdMonth: Month([datefield])

Change it to a Totals query; group by RecdMonth and count and/or sum
the receipts.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

datepart function 2
Concatenate Date and Number field for Append Query 0
Running Sum within Query 4
Return all dates for 'next month' irrespective of year or day 4
Format DatePart 4
Running total in query 2
DatePart function 4
Ato generated control number 1

Back
Top