0
    
          
  
  
    
            Error in formula
Hi
I have an issue with a formula.
When I write a query I have an alarm which says "Expected
end = select to the lire 2, column 6"
Can someone help me ?
Thanks
10 replies
- 
  
You have two lines. Put a
;
after the first line
 - 
  
Thanks but it still does not works…
 - 
  
 - 
  
 - 
  
It is hard to see the select statement above.. but it looks incorrect.

 - 
  
Do you mean no quotes or simple quotes ?
 - 
  
I tried that but …

 - 
  
Lost in the language.. I am not sure what line 1 is attempting. Is this a field formula ??? or a view formula?
 - 
  
In general has to be like this:
select 'Table Name' where 'Field' = "Criteria 1" or 'Field' = "Criteria 2"
e.g.
select Customer where Name = "De Niro" or Name = "Ennio Morricone"
 - 
  
Oops! Sorry @Mconneen...
 
Content aside
- 5 yrs agoLast active
 - 10Replies
 - 1319Views
 


