Is equal to, but not..... 1

[Paul1981]

Hi,

I am trying to do a search on all our customers who have a membership (field- Member0607)

But I also want to get rid of those who dont come to a particular class (field- Class19)

how do I say, mem equal to membership0607 but not equal to class19???

in selection expert you cant put more than one formula in.

Thanks

Paul

 

[lbass]

Don't use the selection expert. Go to report->selection formula->record and enter:

{table.member} = '0607' and
{table.class} <> '19'

You didn't mention the datatypes, so I'm assuming they are both strings.

-LB

 

[Paul1981]

Thank you!!

much better way of doing it!!!

Paul

 

[synapsevampire]

Add to that creating 2 parameters will allow for better flexibility, especially if you create a range parameter for each and then the record selection would be:

{table.member} = {?Memeberparm}
and
{table.class} <> {?Classparm}

Now the report will prompt for the included members and the classes to disregard.

You could also create additional parameters for members to exclude and classes to include.

-k