Use of cast function with MS Access

• clmiller

  SSC Veteran

  Points: 251

  More actions

  February 28, 2008 at 12:50 pm

  #93335

  I am trying to use cast with Access 2007 to convert an OLE field to character. The syntax I have used as SQL with Crystal Reports does not work. Any examples of successful usage of cast?

• Matt Miller (4)

  SSC Guru

  Points: 124210

  More actions

  February 28, 2008 at 12:56 pm

  #783417

  I don't think Access allows for CAST. It uses the more "VB-like" functions for casting: Cstr (cast to string) Clng (long int) cdbl (double) cdate....

  ----------------------------------------------------------------------------------
  Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?