IN Number Formular

[bigdavelamb]

Hi

I have a sql statement similar to this:


Select * from table where myNumberField in (1,2,5,10,20)

Can anyone convert this to Crystal as IN does not seem to work?

Thanks

dave

 

[dgillz]

If you want a formula:

{MyField} in [1,2,5,10,20]

If those are strings, surround each value with double quotes.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[IanWaterman]

In Select expert enter

myNumberField in [1,2,5,10,20]

Generally where SQL uses () Crystal uses []

Ian

 

[bigdavelamb]

Thank you fellas, much appreciated.

Dave