Query Help

From: Scott A. Schell <saschell_at_lucent.com>
Date: Tue, 12 May 1998 15:14:49 GMT
Message-ID: <35586769.9C45A045@lucent.com>

Hi All,

My Table looks like:

month, department, csub, project, amount

    jan, dept1, a, proj1, 1.1
    jan, dept1, b, proj1, 2.2
    jan, dept1, c, proj1, 3.3

...

where csub is one of 4 values (a, b, c, d -- for example).

I need to create a query which results in the following layout:

deptartment, (a), (b), (c), (d)

Where the query returns all departments (by month/project) and for each department returns the amounts for csub a, b, c, d in it's own row for example:

dept1, 1.1, 2.2, 3.3, 4.4
dept2, 5.5, 6.6, 7.7, 8.8
....

(again for a given project/month -- i.e. proj1, JAN...)

Please respond both by email and news.

Thanks

Scott
saschell_at_lucent.com Received on Tue May 12 1998 - 10:14:49 CDT