ASP + Ms Access: Add Now() to datetime data type

sql = sql & "values('" & username & "','" & pwd & "','" & firstname & "','" & lastname & "','" & email & "', " & role & ",'" & status_ & "',Now())"