CarlaKingery
New member
- Local time
- Today, 21:35
- Joined
- May 30, 2002
- Messages
- 8
Oh help, I just need one piece and my database would be perfect...well almost.
I created a union query with the following syntax:
SELECT [Parent Company Name], [IOU], [Count], [SumOfCount]
FROM [Utilparentcount]
UNION ALL SELECT [Parent Company Name], [NonIOU], [Count], [SumOfCount]
FROM [UtilparcountNonIOU]
UNION ALL SELECT [Parent Company Name], [LDC], [Count], [SumOfCount]
FROM [UtilparcountLDC]
It worked beutifully, except I need to have a separate field that shows from what table each record originated. This is important because it tells me what type of utility each record is IOU, NonIOU, or LDC. Any suggestions?
C
I created a union query with the following syntax:
SELECT [Parent Company Name], [IOU], [Count], [SumOfCount]
FROM [Utilparentcount]
UNION ALL SELECT [Parent Company Name], [NonIOU], [Count], [SumOfCount]
FROM [UtilparcountNonIOU]
UNION ALL SELECT [Parent Company Name], [LDC], [Count], [SumOfCount]
FROM [UtilparcountLDC]
It worked beutifully, except I need to have a separate field that shows from what table each record originated. This is important because it tells me what type of utility each record is IOU, NonIOU, or LDC. Any suggestions?
C