Found my issue.
Rod
--- In MS_Access_Professionals@yahoogroups.com, "rodbevill" <desertscroller@...> wrote:
>
> 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 (2) |
Tidak ada komentar:
Posting Komentar