Cross Tab Query

From: Daud (Daud_at_discussions.microsoft.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 03:55:01 -0800

How can I cross-tab the query it was simple in MS-Access but i don't know how
to do it in SQL. the thing i want is as follows:

Simple Query

Item Year Qty
A 1991 10
B 1991 15
C 1991 20

Cross-Tab Query (Items)
                  ITEMS
Year A B C
1991 10 15 20 

-- 
Daud Akbar

Relevant Pages

  • Re: Mutivalued datatypes considered harmful
    ... query return if you brought back the "hobbies" field in an sql query - say ... sql does not - so the mysql/oracle feature was never consided multi-vlaued. ... The extensions to ms-access are real and signcivnetly in this matter. ... transloates to a lookup table, the same would be done for ms-access. ...
    (comp.databases.pick)
  • Re: Mutivalued datatypes considered harmful
    ... query return if you brought back the "hobbies" field in an sql query - say ... sql does not - so the mysql/oracle feature was never consider multi-valued. ... The extensions to ms-access are real and significant in this matter. ... translates to a lookup table, the same would be done for ms-access. ...
    (comp.databases.pick)
  • Re: Mutivalued datatypes considered harmful
    ... SQL, but wouldn't the "DISTINCT" modifier then restrict this to one row? ... So, the above query is perfectly legal!!!, and WILL WORK on multi-value ... The sql in ms-access has been modified. ... supposed problems of multi-value fields does work!! ...
    (comp.databases.pick)
  • Re: Continues Form
    ... You kind of have to clarify what you mean by results of the sql? ... Do you have a query built, ... settings to see how this was done. ... ms-access is kind to you in that changing the recordsouce as ...
    (microsoft.public.access.formscoding)
  • Report based on cross-tab query
    ... Have a report based on a cross-tab ... Have a cross-tab query that arrays ... are no sales for some offices!! ...
    (microsoft.public.access.reports)