Hi

I don't get what you are doing. I presume this is a formula and its results are returned to the record selection formula? If this is a true assumption, then why don't you just put the case statement into the record selection formula and not use a secondary formula? Add this to the case statement:

{praccode.pcode}<>"9999"

Yeah, I figured it was something like this. You can't do what you want to do without getting 'slightly' more advanced. I'll try to explain it, but you might be too new to get it at first. But play around with the idea to see what happens.

You are passing a formula to a record selection formula. But the record selection formula is saying something like "field = parameter". So you let the user choose specific values to put into the parameter. The problem is that the selection formula is using "=" in it and therefore you can never do a "<>" in the value.

What you need to do is go into the record selecttion wizard and clik the Selection Formula button. This lets you modify the entire record selection formula manually. You need to get rid of the part of the formula relating to {praccode.pcode} and instead replace it with an If statment that compares the value based upon this parameter. Here is a quick and dirty sample I just typed into notepad (so I doubt if it will work yet). You will have to fix it to get rid of any syntax errors, but it should give you the idea. Also, I'm making up the first part about your other selection formulas so just put in whatever you need.

If {table.somefield} IN {?DateBegin} To {?DateEnd}
AND
(
{?PCode}="Non-billable" and {praccode.pcode}  = "9999"
OR
{?PCode}="Billable" and {praccode.pcode}  <> "9999"
OR

{?PCode}="All" 

}
Then
True