Combining rows for identical names
- From: zcjxg0 <zcjxg0@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Jun 2005 06:16:04 -0700
I am having a problem with trying to combine some data. Here is an example of
what I have now:
PMgr ExpMW ExpSE ExpTotal IncMW IncSE IncTotal
Smith, John (114.86) (430.32) (545.18)
Smith, John 992.34
100.80 1093.14
Johnson, Jim (47.79) (266.94) (314.73)
Johnson, Jim 149.86
96.03 245.89
I would like to combine the rows for each PMgr:
PMgr ExpMW ExpSE ExpTotal IncMW IncSE IncTotal
Smith, John (114.86) (430.32) (545.18) 992.34 100.80 1093.14
Johnson, Jim (47.79) (266.94) (314.73) 149.86 96.03 245.89
The data comes from two separate crosstab queries. The Exp info comes from a
linked table while the Inc info is manually entered. I am having a brain
freeze and any help would be greatly appreciated. Please let me know if you
need any more info. Thanks.
.
- Follow-Ups:
- Re: Combining rows for identical names
- From: John Spencer (MVP)
- Re: Combining rows for identical names
- Prev by Date: How to organize queries in the Database Window
- Next by Date: Closest Match
- Previous by thread: How to organize queries in the Database Window
- Next by thread: Re: Combining rows for identical names
- Index(es):
Relevant Pages
|
