W
Will Adams
Guest
In a report that shows confidential information about various individuals, I would like replace each individual's name with "********" except for a selected individual in the detail section of a report.
Currently the database contains a global variable that contains the correct string.
If I hard code the item in the Record Source property like:
iif([FullName] = "Doe, John", [FullName], "*********")
Then it works fine. However, with multiple reports, and where I may not know a new name, I would like to plug in the global variable. Whenever I plug in the global gsMasterName, I end up with a parameter query.
Any help would be useful.
I have tried to solve this in the query the form is based on, but get the same problem.
Thanks, Will
Currently the database contains a global variable that contains the correct string.
If I hard code the item in the Record Source property like:
iif([FullName] = "Doe, John", [FullName], "*********")
Then it works fine. However, with multiple reports, and where I may not know a new name, I would like to plug in the global variable. Whenever I plug in the global gsMasterName, I end up with a parameter query.
Any help would be useful.
I have tried to solve this in the query the form is based on, but get the same problem.
Thanks, Will