Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: Cross Tab / Transform

    Access allows one to create a "Crosstab query", which uses a Transform command. Is this standard SQL or is it just an Access extension? Where can I get more information on the syntax?

    Quick question, meantime: Using the "design view" in Access, you can only create a crosstab report on a single table or view (actually saved query, but it's the same idea.) From looking at the generated SQL, it's hard to tell if I can actually use a join here to use two tables, or not. Yes or no?


  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    it is not standard sql, it is an access extension

    syntax would be in the access help file

    yes, you can use a join query fot the source of a crosstab | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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