Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to use two where clauses for the same table:
from...
Where Year("Oppo_Opened")>=2010
Where Field("Oppo_Type") = Record(Sales);
What is the correct syntax for this?
Where Year("Oppo_Opened")>=2010 AND Field("Oppo_Type") = Record(Sales);
Where Year("Oppo_Opened")>=2010 AND Field("Oppo_Type") = Record(Sales);
Use only one Where and And between two conditions...
Something like
Where Customer = 'A' And Country = 'B'
Are you talking about SQL selects, because your where clause does not seem to be QV script load syntax?
Thanks guys!
Definitely on the right track, but my syntax is still off.
For the second one -- how do i do -- WHERE (Fieldname) contains RecordName.
I have several opportunity types, but I only want to load those that have 'Sales' in Oppo_Type field.
Where Oppo_Type = 'Sales';