I want to cast some datatypes in Access 2007. I am used to writing SQL in SQL Server Management Studio. I am having trouble changing datatypes that seems pretty simple.
Cast( 3456 as nvarchar(20))
Cast as a decimal Cast(3.5555 as Decimal(10,2))
Cast as a Date or Cast('12/25/2012 00:00:00' as Date)
Cast as money or Cast (45.678 as Money)
Cast as DateTime Cast('12/25/2012' as DateTime)
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.