Search results

this is what the expression builder gave me when i went to define the control source for the text box on the main report. trying your method still yields the same results. ive also tried changing the if statement to reference the subreport control directly without luck

:banghead::banghead::banghead:Ok so this is driving me nuts. i have a subreport that has a control that sums the number of employees on a project. the subreport calculates this number fine and displays it in the main report no problemo. When i attempt to make a control on the main report that...

this was an absolute lifesaver

I can easily create a query to attain just the data I need, but I will still need to concatenate them together with semicolons

Yeah I think that should work. After further thought about what I need to display, I will end up having to take into account a few other controls (i.e. whether or not the employee is still active) that decide whether or not a name is displayed in the Text Box.

I have a lot of things based off the "Last, First" field being the way it is, so I'll have to give that link a try as a workaround. Thanks for the help!

First off, thanks to everyone who posts here and uses the site, it has been invaluable to my efforts to use access. Currently I'm working on a report in Access 2013 and I have a multivalued field that stores employees names in the format "Last, First" and when I put it on my report it displays...