Results 1 to 14 of 14

Thread: Make Table

  1. #1
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002

    Unanswered:

    not directly, no

    however, if the volume of data is not too big, once you see the crosstab query results in datasheet view, click on the top left corner to highlight all cells, copy, then go to table, new, datasheet view, click on the top left corner, paste, et voila

    don't close the crosstab query results datasheet view just yet, because you now need to save the new table just created, open it again in design view, and systematically rename the columns from Field1, Field2, Field3, etc., to new column names that reflect the values that got cross-tabbed in that sequence

    if you know what i mean
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by r937
    not directly, no

    however, if the volume of data is not too big, once you see the crosstab query results in datasheet view, click on the top left corner to highlight all cells, copy, then go to table, new, datasheet view, click on the top left corner, paste, et voila

    don't close the crosstab query results datasheet view just yet, because you now need to save the new table just created, open it again in design view, and systematically rename the columns from Field1, Field2, Field3, etc., to new column names that reflect the values that got cross-tabbed in that sequence

    if you know what i mean
    Coo - how come you can see the original Thread Rudy? It appears a blank to us non-Super Mods.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    heh, i was wondering if any of you guys would notice

    this thread shows blank for me too -- i just knew what to reply!

    allow me to explain ...

    i remember seeing it here earlier today, and then when it was cross-posted into, ahem, another forum, i answered it, so i thought i would simply paste the answer here too

    neat, eh?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59

    Wink

    don't take it too personally pootle flump, Ican't see it either - mebbe its a thread only open to those accross t'pond, IE those learning/using English as a foreign language or mebbe deities like supermoderators or admins (see the DarkOrange or red UserId and worship)
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Ah - and I saw it duplicated and answered it - though I think in the circumstances a duplicated post is forgivable.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    O. M. F. G.

    i never thought to try it like that -- that's brilliant

    so,
    Code:
    select * into [new table] from [your crosstab query]
    i'll have to tell her on the other forum too

    thanks, pootly
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by r937
    O. M. F. G.

    i never thought to try it like that -- that's brilliant

    so,
    Code:
    select * into [new table] from [your crosstab query]
    i'll have to tell her on the other forum too

    thanks, pootly
    Tks - I deleted the line where I admonished you for using Copy & Paste before I hit Submit
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Shameless Database Guru of the Year (2005).
    Testimonial:
    pootle flump
    ur codings are working excelent.

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what's shameless about it? this is the third year in a row i've won that award, and i didn't give myself that badge, it's awarded by the sitepoint staff

    hey maybe we can get dennis to adopt the same idea over here -- DBFORUMS XXXX GURU OF THE YEAR (where XXXX = database system)

    as far as community spirit and member involvement is concerned, sitepoint has got dbforums beat all to hell, but i can certainly give you guys ideas for catching up

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by r937
    what's shameless about it?
    No "ah - someone else answered your question elsewhere but I'll post it here too for posterity" - I am shocked and shaken to the core.

    Quote Originally Posted by rudeboy
    as far as community spirit and member involvement is concerned, sitepoint has got dbforums beat all to hell, but i can certainly give you guys ideas for catching up
    But I'm sure you'll agree - the direction is at least the right one now.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Oh good Lord - and the answer has been deleted too now:
    http://www.dbforums.com/showthread.p...76#post4518376

    tiddle dee dee
    Testimonial:
    pootle flump
    ur codings are working excelent.

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    oh, i get it -- not shameless because i won that award, shameless that i posted your solution without attribution

    yes, you're right, and i have rectified the post to give you credit

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    oh, i get it -- not shameless because i won that award, shameless that i posted your solution without attribution

    yes, you're right, and i have rectified the post to give you credit

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  14. #14
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by rudytuesday
    oh, i get it -- not shameless because i won that award, shameless that i posted your solution without attribution

    yes, you're right, and i have rectified the post to give you credit

    Aw Rudy - you just aren't as easily provoked as your peers.

    You may take that as a criticism or a compliment as you like
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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