Susan Harkins
harkins at iglou.com
Tue Jun 24 11:54:59 CDT 2003
Martin, does this really have to be a "table" -- could you work with a report or form that looks like a table? I mean, are you really going to be storing the data in this format or do you just have some folks that want to see the data in this particular format? Susan H. ----- Original Message ----- From: Martin Reid To: accessd Sent: Tuesday, June 24, 2003 11:32 AM Subject: [AccessD] SQL Question Have two tables Table A Contains staff data, Name etc Table B contains contact data Results of join as expected Staff Member A Telephone Number 1 Staff Member A Telephone Number 2 Staff Member A Telephone Number 3 And so on What I need to do is to flatten this out and create a single table Staff Member A Phone Number 1 Phone Number 2 Phone Number 3 etc Staff Member B Phone Number 1 Phone Number 2 We dont knwo how many numbers will exist for each member of staff but the Max will be 5 and I must end up with a single table containing the data. Need this to work in Access and SQL Server 2000 Martin ------------------------------------------------------------------------------ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030624/f1e6bde8/attachment-0001.html>