Thanks Jay, I got the solution.
Thanks for all the members responding.
With warm regards,
VR Venugopal Rao
-Original Message-
From: Jay Blanchard [mailto:jblanch...@pocket.com]
Sent: 28 April 2010 16:58
To: VR Venugopal Rao; MySQL
Subject: RE: Pivot Query in
[snip]
Date, ProjectCode
In MS Access I used to generate one pivot query which gets the following
report from the database which contains the following fields:
See "Pivot tables" at http://www.artfulsoftware.com/queries.php .
PB
-
Jay Blanchard wrote:
[snip]
Date, ProjectCode Building, Number of Copies
I want t
[snip]
Date, ProjectCode Building, Number of Copies
I want to get a Connsolidate Report of
Project Code R&D STP
1007304--04---04
(Group by Project Code)(Sumtotal Building wise).
I have tried to execute the following code :
select pcode, building, sum(ncopies) from request gro
On Wed, 2010-04-28 at 15:24 +0530, VR Venugopal Rao wrote:
> I am working on Java-HTML-MS Access Backend database.
>
> Now office is removing all unlicensed softwares and they are removing
> microsoft applications also and hence the necessity to shift from MS Access
> to MySQL has arised.
>
> In
I am working on Java-HTML-MS Access Backend database.
Now office is removing all unlicensed softwares and they are removing
microsoft applications also and hence the necessity to shift from MS Access
to MySQL has arised.
In MS Access I used to generate one pivot query which gets the following
rep
