|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 14th, 2004, 03:29 PM
|
|||
|
|||
DatePart question
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. 
|
|
#2
December 14th, 2004, 06:13 PM
|
|||
|
|||
|
On Tue, 14 Dec 2004 07:29:02 -0800, TorturedSoul
wrote: 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. 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
|
|
#3
December 15th, 2004, 01:17 PM
|
|||
|
|||
|
PERFECT !! Thanks
"John Vinson" wrote: On Tue, 14 Dec 2004 07:29:02 -0800, TorturedSoul wrote: 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. 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
|
|
#4
December 15th, 2004, 01:19 PM
|
|||
|
|||
|
PERFECT !! Thanks
"John Vinson" wrote: On Tue, 14 Dec 2004 07:29:02 -0800, TorturedSoul wrote: 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. 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
|
|
#5
December 15th, 2004, 01:21 PM
|
|||
|
|||
|
PERFECT !! Thanks
"John Vinson" wrote: On Tue, 14 Dec 2004 07:29:02 -0800, TorturedSoul wrote: 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. 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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to get rid of question: 'Save record?' | Randi W | Using Forms | 3 | October 15th, 2004 09:15 AM |
| Help! Access Subform Question | Kristen | Using Forms | 1 | September 24th, 2004 01:32 AM |
| whats a good way to start a paragraph with a question in mind.. | kr33p3r | General Discussion | 2 | September 2nd, 2004 10:59 PM |
| Word question regarding TOC (newbie question)... | Herman Geerlings | Formatting Long Documents | 4 | June 4th, 2004 03:12 PM |
| Designing a question paper | Ken | New Users | 2 | April 28th, 2004 10:13 PM |
Linear Mode
