Good Afternoon All,
I am trying to add a where clause to an named query. The initial query is :
SELECT [tblDBUsers]![strLastName] & ", " & [tblDBUsers]![strFirstName] ASAuditor, " _
& "tblProjectType.strProjectType, Qry_Auditor2Project.lngTPTID, Qry_Auditor2Taxpayer.strTaxPayerName, " _
& "Qry_Auditor2Taxpayer.strTPT, Qry_Auditor2Project.strResearchDate, Qry_Auditor2Project.lngUserID, Qry_Auditor2Project.lngProjectTypeID" _
& " FROM ((Qry_Auditor2Project INNER JOIN Qry_Auditor2Taxpayer ON Qry_Auditor2Project.lngTPTID = Qry_Auditor2Taxpayer.lngTPTID) " _
& " INNER JOIN tblDBUsers ON Qry_Auditor2Project.lngUserID = tblDBUsers.lngUserID) INNER JOIN tblProjectType ON Qry_Auditor2Project.lngProjectTypeID = tblProjectType.lngProjectTypeID " _
& " ORDER BY [tblDBUsers]![strLastName] & ", " & [tblDBUsers]![strFirstName]; "
Want to add the following WHERE clause:
& " WHERE (((Qry_Auditor2Project.strResearchDate)>#4/1/2013# And (Qry_Auditor2Project.strResearchDate)<#8/24/2013#) AND ((Qry_Auditor2Project.lngUserID)=4) AND ((Qry_Auditor2Project.lngProjectTypeID)=1)); "
when the ";" is deleted from the original sql then the WHERE clause is appended an error message is generated. Error 3075 missing operator. Everything seems to work without the WHERE clause except I don't get the filtered results. This filtered query is being used to export data to EXCEL.
Thank for any help
Rod
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar