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
|
|||
|
|||
Add to rows in the same table with query?
Hello I am relatively new to MS Access 2003 and have a question that is
probably quite simply to answer. I have a a query from a report data table with the following structu Station ID Date Value HRO 12/30/05 13.65 TRP 12/30/05 16.98 DTO 12/30/05 68.45 What I would like to do is expand this query so that will add HRO and TRP but leave DTO as it is. Any suggestions on how this can be accomplished? Thanks. Jon |
#2
|
|||
|
|||
Add to rows in the same table with query?
If you can assign those two records to a group. (i.e. Add a new column to
the table, and assign the same value to those two records.), then you could group the data and perform the totals. -- Steve Clark, Access MVP http://www.fmsinc.com/consulting *FREE* Access Tips: http://www.fmsinc.com/free/tips.html "Monsignor JAV" wrote in message ups.com... Hello I am relatively new to MS Access 2003 and have a question that is probably quite simply to answer. I have a a query from a report data table with the following structu Station ID Date Value HRO 12/30/05 13.65 TRP 12/30/05 16.98 DTO 12/30/05 68.45 What I would like to do is expand this query so that will add HRO and TRP but leave DTO as it is. Any suggestions on how this can be accomplished? Thanks. Jon |
#3
|
|||
|
|||
Add to rows in the same table with query?
Thanks Steve but could you elaborate a little bit more please. Is this
going to be possible without creating a new column of data in the existing table of records. We have many more records with different station IDs besides the three I used as an example. I would like to be able to do this without disrupting the intrgity of the existing table and other queries. I was thinking about it this weekend and thought perhaps there is a way of doing a preliminary query for the HRO and TRP stations and then another query for the rest. Does this sound like a step that does not need to be taken? Like I said before the more the advice the merrier. Thanks. Jon |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Unmatched Query Mess | Natalia | Running & Setting Up Queries | 8 | October 28th, 2004 02:36 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |