Retrieving array data elements using a query

[carvind]

Can some one guide me posting an example to retrieve data stored in an one-dimensional array using a select query? Thanks in advance for your help.

 

[Galaxiom]

Create a Public Function in a Standard Module that retrieves the designated value from the array.

Call the function from the query.

 

[boblarson]

You would have to create a wrapper function in a standard module.

Function GetMyArrVal(x as long) As WhateverDataTypeItIs
   GetMyArrVal = arrayName(x)
End Function

Then you would pass the element when calling.

MyFieldNameHere:GetMyArrVal([Field1])

or

MyFieldNameHere:GetMyArrVal(1)

 

[boblarson]

And I was slow on typing that all up.

 

[Galaxiom]

And I was slow on typing that all up.

Sure but your answer was actually what the poster asked for, an example.