Expand|Select|Wrap|Line Numbers
- strSQL = "SELECT Max(EntryType) AS MaxOfEntryType " & _
- "FROM tblForecastData GROUP BY BusinessLine, [Packaging Location], Week " & _
- "HAVING ((([Packaging Location])='" & xx & "') AND ((Week)=" & xx & ")) "
Run-time error '3075':
Extra ) in query expression '((([Packaging Location])=") AND
((Week)=))'.
If I remove the ('s I receive an error stating that there are (operators missing). Is there anything obviously wrong someone would please point out to me?
Thank you,
Nadnerb