Add to rows in the same table with query?

  • Thread starter Thread starter Monsignor JAV
  • Start date Start date
M

Monsignor JAV

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 structure:

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
 
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.
 
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
 
Back
Top