I want the value of a label on my report to change depending on the value of the [PIINType] field. For example, if the [PIINType] is "Purchase Reqn", I want the label to be:
"Estimated Award Date: " & [ContractDate]
If the [PIINType] is "Contract", I want the label to be:
"Contract Delivery Date: " & [ContractDate]
I have other values for the [PIINType] field but I only want one field to store the date.
The report runs off a paramenter query (I know, y'all hate those). I'm thinking I should be able to use a nested If, then, else statement or Select Case in the report's Open event but I cannot figure it out.
Any suggestions are deeply appreciated.
"Estimated Award Date: " & [ContractDate]
If the [PIINType] is "Contract", I want the label to be:
"Contract Delivery Date: " & [ContractDate]
I have other values for the [PIINType] field but I only want one field to store the date.
The report runs off a paramenter query (I know, y'all hate those). I'm thinking I should be able to use a nested If, then, else statement or Select Case in the report's Open event but I cannot figure it out.
Any suggestions are deeply appreciated.