View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming, microsoft.public.access.queries
onedaywhen[_2_] onedaywhen[_2_] is offline
external usenet poster
 
Posts: 74
Default Switch() causes strange ADO result

Lynn Trapp wrote:

Apparently, Jet is confused about the datatype. Try modifying your
.Source argument


Thanks for suggesting a workaround. However, the query is merely
academic. I'm interested in source of the problem or at least why the
result is of type adVarBinary.

Thanks again,
Jamie.

--