criteria used in query

[bnageshrao]

In access query when I put the value of “Referral - AC (H&W)” in the criteria field I am getting the following error.

The expression you entered has an invalid .(dot) or! Operator or invalid parentheses
You may have entered an invalid identifier or typed parentheses following null constant.

I have to get all records from the table where field value = "Referral - AC (H&W)”.

Is there a way I can run the query?. Do I have to use any single quotes around parentrheses or is there any wild chaarcters? Any help is higly appreciated

 

[SkipVought]

Hi,

Enter that string in [tics]
[tt]
'Referral - AC (H&W)'
[/tt]



Skip,
[sub]
[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE[/sub]

 

[VhbuiA]

Let's see your SQL statement...I tested it on my end and it shouldn't be a problem. Could be a typo.

 

[bnageshrao]

Here is the sql statement
IIf([leadforpicklist]![LEADSOURCE]= “OneSource”, “OneSource”, IIf([leadforpicklist]![LEADSOURCE]= “Sales Rep Generated”, “Sales Rep Generated”, IIf([leadforpicklist]![LEADSOURCE]= “Marketing
”, “Marketing”, IIf([leadforpicklist]![LEADSOURCE]= ‘Referral - AC (H&W)’, ‘Referral - AC (H&W)’, IIf([leadforpicklist]![LEADSOURCE]= ‘Referral - AC (Other)’, ‘Referral - AC (Other)’, IIf([leadforpicklist]![LEADSOURCE]= “Referral – ARS”, “Referral – ARS”, IIf([leadforpicklist]![LEADSOURCE]= “Referral – Other”, “Referral – Other”, “Other”))))))))

I used single quotes around the values which has parentheses and I still i get the same error, but if i use only one value with single quotes it works, I dont know why it is not working when i use it with other values. Any suggestion?

 

[SkipVought]

Use [tics] on EVERYTHING.


Skip,
[sub]
[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE[/sub]