Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello.
    In Access 2003 I have created a table with a single field Year and the values 80,81,81. I'm then using this table
    to create a 'cross-product' with another table. That is, to repeat each row for each of the years 80, 81 and 82.
    Is it possible to amend the SQL statement to include these values directly (without having to maintain a separate table)?
    Thanks, Andy.

    SELECT WideForm.id, Years.year, WideForm.sex, Choose([year]-79,[inc80],[inc81],[inc82]) AS inc
    FROM WideForm, Years
    ORDER BY WideForm.id, Years.year;

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Quote Originally Posted by andrewgibsonsw View Post
    Is it possible to amend the SQL statement to include these values directly (without having to maintain a separate table)?
    Not as far as I know.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, fair enough. Andy.

Posting Permissions

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