Multi Value Field Causing Problems in Reports

[LordPanzer]

My problem is with a multi value selection box and how it screws with my reports. My main concern is having no other option then to remove the multi value field and replace it with something else. Currently the field contains default values from a seperate table and even though it has all required fields as 'yes' to allow user input, it does not take submissions. You can see from the picture below how it prints out. The reason the multi value field is the problem is it creates multiple istances of the same 'Phase(s)' and 'Effects of failure Conditions and Airplane, Crew, and Occupants'. You can see under 'phase(s)' it has Parking, Takeoff, and Taxi. With 3 different values selected it creates 3 'Phase(s)' and 'Effects'. The picture below shows what it looks like but you can see it only shows one that is because I have 'Hide Duplicate' as yes but you can the space between the above information and the data and page number where they would be. I'm wanting to completely remove those submissions so the white space would be gone and a single values would be present. If you need more information or data from my Access program feel free to ask, but I will not be able to give you the entire project per company restrictions.




Printout View

[June7]

I expect this 'repetition' of info would happen even if did not use multi-value field. This is because a multi-value is actually multiple records, they are in a hidden table that Access manages as part of the multi-value field. So if you did instead use a child table and created multiple records for these multi-values, the result would be the same. The issue is the data relationships and the report recordset. Perhaps you need to use report Grouping & Sorting features or subreport. Without closer examination of db, can't be specific.

[ssanfu]

Maybe you could use a child table (get rid of the MVF), then concatenate the values in the query when opening the report.

See "Concatenate values from related records"
http://allenbrowne.com/func-concat.html

[LordPanzer]

Thanks guys I was able to get it working. I used the Query suggestions to simply take all information stored in the Main Table and transfer it to the Query. I'm not sure how this lifts the issue of duplicating a multi value field but it does. So simply create a query that takes all values you want to print from the main table, and create a report using the queries values instead of the tables. Thanks again guys, solved.

Current Printout