Reformat Recordset

Results 1 to 2 of 2

Thread: Reformat Recordset

  1. #1
    Nhi Tran Guest

    Default Reformat Recordset

    I need to turn a recordset into a Crosstab/Spreadsheet like format and I don&#039t know how to do it. I tried Loops but it doesn&#039t work.<BR><BR>The data comes back as<BR>Store Week Amount<BR>1234 1 4645<BR>1234 2 4987<BR>1234 3 7964<BR><BR>I need it to look like<BR>Store Week1 Week2 Week3 Week4<BR>1234 4645 4978 7964 4967<BR>2345 4645 4978 7964 4967<BR><BR>Any help is greatly appreciated. Thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: Reformat Recordset

    Why don&#039t you try using a stored procedure and a temporary table?<BR>It&#039s kind of complicated to post the solution here.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts