Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've created a calendar view to display team time off. However, when more than one have the day off, I do not see both names. How can I see this?
For each of the days above, multiple people are off with Off_Type of either vacation or comp day, with the exception of Wed.
The expression is: [Full Name]& '-' & Off_Type
How can I see all items for each day?
May be use Concat() function
Concat(DISTINCT [Full Name] & '-' & Off_Type, Chr(10))
May be use Concat() function
Concat(DISTINCT [Full Name] & '-' & Off_Type, Chr(10))
Perfect...thank you so much!