SQL Syntax Error

From: michelleumich <mahampto@xxxxxxxxx>
Date: Thu, 05 Jul 2007 11:15:33 -0700

Hi, I am creating a search Query using SQL adapted from an online
resource. While 'translating' the code to adapt to my Database I
received a syntax error notification while trying to run. I have
searched through the parenthesis and cannot find the Error! Does
Microsoft access have false error notifications sometimes? Is this a
bug I should be aware of? Is it a problem with my code?
Here is the code:

PARAMETERS [Forms]![QueryMultiValueSearchForm]![txtFilterName] Long,
[Forms]![QueryMultiValueSearchForm]![txtFilterUMID] Long, [Forms]!
[QueryMultiValueSearchForm]![txtProjectGrant] Long;
SELECT tblClient.*
FROM tblClient
WHERE IIf (([Forms]![QueryMultiValueSearchForm]![txtFilterName] Is
Null) ,
IIf(2007-08ScholarshipMaster.Name Like "*" & [Forms]!
[frmClientSearch]![txtFilterName] & "*"))
AND (([Forms]![QueryMultiValueSearchForm]![txtFilterUMID] Is Null)
OR (2007-08ScholarshipMaster.UMID = [Forms]!
[QueryMultiValueSearchForm]![txtFilterUMID]))
AND (([Forms]![QueryMultiValueSearchForm]![txtProjectGrant] Is
Null)
OR (2007-08ScholarshipMaster.ProjectGrant = [Forms]!
[QueryMultiValueSearchForm]![txtProjectGrant]))
AND (([Forms]![QueryMultiValueSearchForm]![txtStartDate] Is Null)
OR (2007-08ScholarshipMaster.ScholarshipStart Like "*" & [Forms]!
[QueryMultiValueSearchForm]![txtStartDate] & "*"))
AND (([Forms]![QueryMultiValueSearchForm]![txtFilterName] Is Null)
OR (2007-08ScholarshipMaster.ScholarshipStart Like "*" & [Forms]!
[QueryMultiValueSearchForm]![txtStartDate] & "*"))

If anyone spots any obvious errors let me know.
Thanks,
M

.

Follow-Ups:
- Re: SQL Syntax Error
  - From: Marshall Barton
- Re: SQL Syntax Error
  - From: kingston via AccessMonster.com
- Re: SQL Syntax Error
  - From: John Spencer

Prev by Date: RE: Display fields Limited on Values
Next by Date: Re: SQL Syntax Error
Previous by thread: Re: i need simple process if there is any
Next by thread: Re: SQL Syntax Error
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Syntax Error
... received a syntax error notification while trying to run. ... Microsoft access have false error notifications sometimes? ... SELECT tblClient.* ...
(microsoft.public.access.queries)
Re: SQL Syntax Error
... Seond can you describe what you are attempting to do in that where clause? ... SELECT tblClient.* ... Access MVP 2002-2005, 2007 ... received a syntax error notification while trying to run. ...
(microsoft.public.access.queries)
Re: SQL Syntax Error
... Comparisons for strings need the text qualifier " or ' unlike numeric ... received a syntax error notification while trying to run. ... SELECT tblClient.* ...
(microsoft.public.access.queries)