I am be so off track here it might make you laugh.
I tried to work with SQL and Queries to get the results I needed but it isn't working. So I made a recordset a manipulated the data as I needed and stored them within an array.
I would like these results now to be displayed on another form. These forms were currently set up to be opened by a SQL line from a query. The form was continuous so it displayed like a grid.
How can I make a temp query with the values in my array and display them on these forms in a contunous format?
I am just thinking if I am able to find a simple solution to throw this data back into a query it would save me the trouble of writing annoying code to display this data.
I tried to work with SQL and Queries to get the results I needed but it isn't working. So I made a recordset a manipulated the data as I needed and stored them within an array.
I would like these results now to be displayed on another form. These forms were currently set up to be opened by a SQL line from a query. The form was continuous so it displayed like a grid.
How can I make a temp query with the values in my array and display them on these forms in a contunous format?
I am just thinking if I am able to find a simple solution to throw this data back into a query it would save me the trouble of writing annoying code to display this data.