[AccessD] reporting and multi-value fields

Best advice. Avoid multi-value fields like the plague.  They are an abomination in the eyes of 
Codd :)

Second best - you need to separate them out in the underlying query, put a report grouping 
on the primary record's key and put the rest of your information in the section header with 
only the MV values in the detail section


-- 
Stuart

On 5 Dec 2014 at 11:13, Susan Harkins wrote:

> From a reader -- it isn't something I've had to deal with -- any links
> to good info or some advice for this guy?
> 
> Thanks!
> Susan Harkins
> 
> Hi Susan, great short synopsis on using multi-value fields in Access
> 2010. But from a reporting end, how would you handle such a field? For
> example, if I'm capturing error types and the user picks four errors
> then this would be recorded as a memo field with the value separated
> by commas. Yet this is not advantageous for reporting purposes. I
> would have to parse the data to extract each of the values. Am I
> correct on my understanding? Your input would be highly appreciated.
> -- AccessD mailing list AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd Website:
> http://www.databaseadvisors.com
>