can i put the result in array?

[dada]

i have this code:

strSQL = "Select * From Transaction Where TimeIn=#" & Me.cTime & "# And EntryDate=#" & Me.ccDate & "#"

can i put the result of this query into an array? in php code.. i will have this code to put it in array..

$query = mysql_query("Select * from Transaction where TimeIn = '".$text1."' And EntryDate = '".$text2."'");
$result=mysql_fetch_array($query);



$field1 = $result['field1'];
$field2 = $result['field2'];
$field3 = $result['field3'];

is there a way to do this in access? thanks in advance!

[dada]

oh.. i have figured it out already.. no need to reply with this thread..