Combining 2 fields into 1 in query 1

[eadiem]

I am trying to create a query with one field called "Complaint Type". It will get data from two fields in a single table called "Complaints 2003", the fields are "Type1" and "Type2". The idea is to create a pie chart with all the complaint types summarized by type (noise, frequency, etc) without regard to whether it's type1 or type2.
My problem is getting the 2 fields to combine into 1 field...any ideas on how to do this through SQL?
Thanks.
Eadie

 

[TonyJollans]

Hi eadiem,

What is in these fields, and how, exactly, do you want them 'combined'? For example, if you have one record with Type1=Noise and Type2=Frequency what do you want output?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[eadiem]

Sorry for the confusion, I'll try to clarify.

The table has records:
ID Type1 Type2
1 Noise Frequency
2 Frequency (None)
3 Other (None)

I want the query to output:

Noise
Frequency
Frequency
Other

Then in my pie chart I will have a slice for each type, where the frequency slice is 50%, noise is 25%, other is 25%.

Hope that makes sense, let me know if I need to explain beter.

Thanks, Eadie

 

[Golom]

Try a union
[blue][tt]
(Select Type1 As [TheType] From tbl Where Type1 IS NOT NULL)

UNION ALL

(Select Type2 From tbl Where Type2 IS NOT NULL)
[/tt][/blue]

 

[eadiem]

Thank you so much Golom! This was exactly what I needed and it worked perfectly.