Displaying one of two parameters in one field on report

[SparkleTrangerine]

Hi
I have two queries for one report. Depending on which
query is run, my user parameters will have a differnet value. Does anyone know how to disply one or the other depending on the query run. I do have code written in the afterform for calling the right query based on a selection in the parameter form.

Any help would be great!.

Thanks
Serena

 

[SparkleTrangerine]

Actually, never mind, I figured it out. I just set the old parameter equal to the new parameter in the afterform code where I am checking for the query to run. Just incase anyone else every comes accross this.

Serena

 

[nagornyi]

Create a formula column that would return value based on the parameter. Then source a field with the column.