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
