Search results for query: *

Thanks for your suggestions, but I am not sure either of these solutions are what I need. I do not have any null fields in my table (though I tried something like this with a view). Only one parameter will be entered each time the report is ran. The parameter will either be 1. an acct number...

My report is built from a view of a table that holds the field {a04_anum} and also the field {PAP}. The {a04_anum} field is really just an account number field and the {PAP} field holds an indicator that identifies the account status. When running the report the user is prompted to enter an...

That is what I want, however, the formula you provided works in that it returns no errors and allows me to save it and use it in my report, but when I run the report using a parameter value that I know is not in my table, I get nothing. The other two parts of the formula are working as expected...

I am trying to write a forumula that is based on my parameter field being found in a database field and displaying a value based on this. If the parameter field value is not found in the database fields I want to display a different value in my formula. This is the formula I have tried but I...