EDIT:  I need each of the MixNumbers to be in a separate field in the query.
Thanks

Do you have an image to show? Reading your question makes me think of a couple things you could mean.

Are you asking how to do 15 Mix numbers in the same row?
If so thats just making your own expressions, Mix1: MixNumber & "1" kind of thing

Or do you want all 15 Mix numbers to be in the query on their own rows?
Thats Union Query

Currently they are all in the same field in the order table.  Several orders make up the table with multiple of each mix listed in the field.  I want each mix number to be in separate fields in a query.  Each will then eventually be related to a table with the plants that go into each mix.

I will go about it this way.

Create a mix table as this:

MixID Auto number
MixNumber Short Text
MixDescription. short Text

Then you can create a query where you link the OrderT to the mixT on the MixNumber field.

Hi Tim
Sami's way is the best way; however it will also work using an alias for each MixNumber.

John