Variable Report Filter

[phillipsrhit]

While creating a report, I need to prompt the user to enter the name of row in the table that is being reported. If the user leaves the prompt empty, I want to show all rows. Else, I want to check the prompt against a particular field in the table, and just report that one row.

I have figured out how to turn the filter on and off by looking to see if the prompt is null. But where I am getting stuck is when I try to enter the string to be used as the filter (ModName = module_name) where module_name is the table field and ModName is the variable I saved the prompt as. How can I make the filter work?

Thanks for your help.

 

[phillipsrhit]

I have figured this out. Thanks anyway for your time.