Selection Formula

[wawanz]

Hi guys...
I use VB 6.0, Access 97, CR 4.6
I have a problem. Let's say I have 10 records under the field name "Number". 001,002,003,...010. What do I put in my selection formula if I want to display 001,003,004,006,007,009 in my report? I randomly picked those numbers from my VB application. The problem is that the numbers I picked can't be assigned to a special condition...
Thanks a lot...

 

[oldwiseone]

One way that you could do it is to use a recordset to select your Records and then print the recordset using a ttx file.

 

[dgillz]

{YourField} in ['001','003','004','006','007','009']

You could also create a multi value parameter field and havbe the user pick as many as deisred to be on the report, in which case your record selection formula becomes:

{YourField} in {?MultiValueParameter} Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[wawanz]

hey Mr. Dgillz....your advice worked perfectly!! Thanks a lot