[AccessD] reporting and multi-value fields

If I understand properly, normalize / expand your entities. In this case,
sounds like this user could benefit from a cross table to create a many to
one relationship of reported error types to events/incidences.

On Fri, Dec 5, 2014 at 11:13 AM, Susan Harkins <ssharkins at gmail.com> 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
>