Combine three columbs for report...???`

[asmodius]

Hello All,

I have a problem that I don't know how to solve. Most likely this has been solved a hundred times around here so I just need to know what to search for and Ill do the work myself. Here goes:

I have a customer service database. In each record customer service personel can describe three different problems through combo boxes 1-3. For instance the form has Description 1, Description 2, and Description 3. All of these boxes come from the same table, but go to three different columbs in my output. I need to create a report that tells me how many occurences of each description there was. I have the report running for description 1, but I don't konw how to get it to add description 2 and description 3. I figure there probably has to be some kind of query that takes all three columbs and combines them into one long one so that I can just have the x axis of the chart be that query, instead of the Descriprtion 1 field in the output table.


Cheers,

Andy

 

[Blainesr]

HOW TO DO IT!!

This is called a Union query.

The code looks like this SELECT [field] FROM [Table, query] UNION ALL SELECT [field2] FROM [table or other table];