I'm getting the following errior in an Access 2010 Module
Microsoft Access can't find the object 'SELECT tbl_HPCODEs.LOB, dbo_RVS_AUTH_MASTERS.REQPROV_KEYID, dbo_RVS_AUTH_MASTERS.AUTHPCP_KEYID, dbo_RVS_AUTH_MASTERS.STATUS, dbo_RVS_AUTH_MASTERS.MEMB_KEYID, dbo_RV_AUTH_DETAILS.AUTHNO, dbo_RV_AUTH_DETAILS.PROCCODE, Trim([PROCCODE]) AS P1, dbo_RVS_AUTH_MASTERS.REQDATE INTO tbl_VV_2011_Auths FROM tbl_HPCODEs INNER JOIN (dbo_RVS_AUTH_MASTERS INNER JOIN dbo_RV_AUTH_DETAILS ON dbo_RVS_AUTH_MASTERS.AUTHNO = dbo_RV_AUTH_DETAILS.AUTHNO) ON tbl_HPCODEs.HPCODE = dbo_RVS_AUTH_MASTERS.HPCODE WHERE (((dbo_RVS_AUTH_MASTERS.STATUS)="1") AND ([REQDATE] between #10/01/2011# and #12/31/2011#));'.
If I copy the query to the query editor it runs fine with no changes. In the module it errors. This is done in a module because the date parameters are coded the start and end date are for the previous quarter. What am I missing??