Hi, I am designing a reporting tool for my company on Access 2010 and everything has been going great so far. All my forms and tables work properly. However, today I have started designing the report itself. In one of my subreports, I have a multi value field, but instead of displaying all the values present in one entry, it shows up multiple reports for each different value that field may have. For instance example, if my report was supposed to show ID = 1 MultiValue = 1, 2 instead it shows ID = 1 MultiValue =1, ID = 1, Multi-Value = 2.
I don't have any problems with Multi-Value fields in the parent report, they all show only once.