Susan Harkins
ssharkins at gmail.com
Sun Mar 2 16:32:02 CST 2014
Yeah, I knew that. I was just hoping. :) The reader found a solution though, so I'm off the hook. :) Thanks! Susan H. On Sun, Mar 2, 2014 at 5:18 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote: > They're not actually stored all together in the original table - it just > looks that way. The are > really normalized child records which are hidden by the system. > > This is just one of the many reasons that MVFs should be avoided (along > with attachment > and hyperlink fields). > > -- > Stuart > > On 2 Mar 2014 at 13:18, Susan Harkins wrote: > > > A reader wants to append the values in a multivalue field to a second > > table, but he wants to append them as is - in a single row. By > > default, an append query creates a new row for each value. Seems like > > it should be easy to tell Access to keep them all together as they're > > stored in the original table, but I'm not finding it. Any help? > > > > > > > > Susan H. > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >