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
|
|||
|
|||
Date group
I used a crosstable query to combine information. I need to know how to
combine all date groups of the same date. I may have two or three fields of 5/05/05, however I want one set of information. Here is an example... I want this: 05/05/05 3.00 05/05/05 2.45 05/06/05 1.00 to become this: 05/05/05 5.45 05/06/05 1.00 |
#2
|
|||
|
|||
On Tue, 7 Jun 2005 13:01:04 -0700, "dogpigfish"
wrote: I used a crosstable query to combine information. I need to know how to combine all date groups of the same date. I may have two or three fields of 5/05/05, however I want one set of information. Here is an example... I want this: 05/05/05 3.00 05/05/05 2.45 05/06/05 1.00 to become this: 05/05/05 5.45 05/06/05 1.00 Create a Query based on your table. Change it to a Totals query by clicking the Greek Sigma icon (looks like a sideways M); leave the default Group By on the date field, and change it to Sum on the number field. If the date/time field contains (concealed) time portions, you may need to group on a calculated field: DateOnly: DateValue([datefield]) John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Subtract a group of cells from a total based on ending date | Nicholas Scarpinato | General Discussion | 0 | May 17th, 2005 03:25 PM |
ambiguous outer joins | renwick | Running & Setting Up Queries | 3 | February 22nd, 2005 02:29 PM |
Group By Date question - date format needs to be "general" | chris | Running & Setting Up Queries | 1 | October 25th, 2004 09:09 PM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 05:08 PM |