Sorry for the cross posting but I'm getting desperate!!!!

Can anybody help with these two database posts. One's nested select statements and the other is an error undefined function for a VB function I am trying to use in SQL.

http://www.vbforums.com/showthread.p...hreadid=200094
http://www.vbforums.com/showthread.p...hreadid=200078