I still don't understand your problem. You seem to understand the concept of using SQL code, so where's the problem in using a SELECT statement?

Secondly, as I already pointed out, the UDF Fourm contaisn a complete set of UDFs designed to interface with databases, including MS Access. Use them!

Also what is this
code:
:End
EndFunction
doing in your code if you don't even create a function or subroutine? [Confused]
_________________________
There are two types of vessels, submarines and targets.