Results 1 to 7 of 7

Thread: [RESOLVED] Access: Multiple Select through 1 select statement

Threaded View

  1. Aug 5th, 2005, 08:45 AM #1
    kfcSmitty
    kfcSmitty is offline

    Thread Starter
    PowerPoster kfcSmitty's Avatar
    Join Date
    May 2005
    Posts
    2,248

    Resolved [RESOLVED] Access: Multiple Select through 1 select statement

    View post #4






    I am not exactly sure how to explain this, but here is what I want to do:

    I have a table, with a layout as follows

    SplitNumber ID Course1 SD1 ED1 Course2 SD2 ED2...

    up until 15

    Now, I want to run a query to take that row, and place it into another table in the following layout

    Course SD ED
    Course2 SD ED
    Course3 SD ED

    up until 15

    I have tried thinking of ways to do it with a query, but have run short. And I cant seem to find any reference to this sort of problem in any of the books I have.

    If anyone could even point me in the right direction with some keywords to search or anything I would greatly appreciate it.
    Last edited by kfcSmitty; Aug 5th, 2005 at 09:42 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width