Length Limits on MS Access Filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I appear to be encountering length limit problems on a few SQL filters.
Following is an example. Any assist or workaround would be appreciated. I
tried using the wildcard around an individuals name and it does not work.


Sample Filter:

Where I am selecting the Region = New York and various employees that have
been assigned to tasks that are not complete.

(((Region="New York")) AND ((tblTask.AssignedTo="Last Name1, First Name"))
OR ((tblTask.AssignedTo="Last Name2, First Name2"))) AND ((Not
tblTask.Status="Completed"))
 
What happens when you run this? Where are you running this from? Do you get
an error message? Are you sure of the parentheses locations? Should it look
like:

WHERE
(((Region="New York") AND (tblTask.AssignedTo="Last Name1, First Name"))
OR
((tblTask.AssignedTo="Last Name2, First Name2") AND (tblTask.
Status<>"Completed")))
 
Thank you for responding. I'm running this from the Filter Management Form
and receive the error 'Problem -- syntax error - missing operator' )]. I'm
verified all syntax there are no missing operators, it happens when the
statement gets to a certain length.
 
Did you try the statement I posted earlier? I changed some things, and it
might work after you substitute the terms with real values.
Thank you for responding. I'm running this from the Filter Management Form
and receive the error 'Problem -- syntax error - missing operator' )]. I'm
verified all syntax there are no missing operators, it happens when the
statement gets to a certain length.
What happens when you run this? Where are you running this from? Do you get
an error message? Are you sure of the parentheses locations? Should it look
Click to expand...
[quoted text clipped - 18 lines]
Click to expand...
 
Back
Top