Put query data in array

[lawdy]

I there any way to put the query results into an array so it can be used. I now put the results in a table (using the make table query). For instance, i may query 6 or so records from a table. Each record may have 5 or 6 fields. Is there anyway to refer to any field in any of the records without first putting them in a table?

[rzw0wr]

Refer to the query by name.

Dale

[pbaldy]

Refer to them to do what? You can open a recordset on the query.

[Cheryl R]

Sorry, but this question is confusing.
You do not have to make a new table every time you query info from tables.
Please be more specific with your question and you will receive more specific answers.
Start with your definition of an array. Does this mean that it simply creates a list for you to do something else with?
Explain in simple terms what you are trying to accomplish.

[orange]

I suggest you tell us in 3-4 lines WHAT exactly you are trying to do in plain English - no table or queries etc... Once we know what you are trying to do I'm sure more focused comments will follow.