I have a customer report that displays cust#, address, site#, deliveries ona weekly basis. There is a parameter which is named "Service Status" and we type in "Active" or "Stopped Service" or "Both" to show customer info. There is no date field in any of the columns but the the selection criteria is referenced to a date field in the database, so meaning if there is no date value in the database "Active is chosen and if there are date values in the database then "Stopped service" is chosen and if "Both" is chosen then it has all the date values. My question is what kind of formula do you write for a parameter with string based selections using a date field? The parameter is not supposed to show a date field either, so I am lost in this case. so the customer data is based of a date field, but no date field is shown in the parameter or report columns. the date field to be used has null values and thats where its "Active".Hope somebody can help and will be greatly appreciated.

Thanks alot for the reply and the solution. I will try it out and see what I get.