Query Output

[bkirby]

I have an Access query that customer data from a fees table:

CustomerID, Fee 1, Fee 2, Fee 3
111,25,34.44,39
222,100,23,45
333,74.50,11,500

Is it possible to output a new record for each fee?
111,25
111,34.44
111,39
222,100
222,23
etc.

Any insight would be much appreciated. Ideally, I'd like to output in a text file.

[bkirby]

I'm good to go. I was able to write a union query to accomplish my goal. Thank you.