[AccessD] SQL Question

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>


More information about the AccessD mailing list