In one of my tables, there is a date field which shows dates of an event happening (called "Issue Date"). This gets input through various measures. Input form or directly into the table or query.
One of the reports I am trying to design is a report that will show all materials that have been issued.
This date field is one of the field which I want to show in the report but I don't want the result to be the date itself. I want the report to replace the date (what ever the date might be) with the value "ISSUED".
Seems like a simple task but I am pulling my hair out trying to figure it out.
Can you offer any help?