how to get this in access 2007 as a query

DECLARE @Date int

SET @Date =DAY(getdate())

--SELECT DateAsInteger = CAST (CONVERT(varchar,@Date,112) as INT)

SELECT DateAsInteger =cast(convert(nvarchar,@Date,112)as int)