APPEARING OF RECORDS IN REPORT

  • Thread starter Thread starter S.K.JAJPURIA
  • Start date Start date
S

S.K.JAJPURIA

Hi friends,
I am very new to access, and want to utilise the
capability of the data base to the results of analysis
appearing through the instrument XRF in Cement Industry.
The query prepared from the linked tables is as under:

Date time Sampleid Constituentid Constituentvalue

Constituents are as Follows:
SiO2; Al2O3; CaO; MgO; Na2O, K2O, SO3
In the report generted,the Constituent value picked from
the query, appear against them, in coloumnar format,
occupying much of the space, of the report.

I would like the data to appear in rows, as exemplified:
Date Time sampleid SiO2 Al2o3 Cao MgO Na2o K2O SO3
Data-->
To sum up, the headig should be as labels, while the data
should be in rows, in condensed form.

Looking forward

Sincerely

Jajpuria
 
The way to do that is to create a crosstab query:
TRANSFORM Avg(YourTable.Constituentvalue) AS
AvgOfConstituentvalue
SELECT YourTable.[Date time], YourTable.Sampleid, Avg
(YourTable.Constituentvalue) AS [Total Of Constituentvalue]
FROM YourTable
GROUP BY YourTable.[Date time], YourTable.Sampleid
PIVOT YourTable.Constituentid;

Copy the above to the sql window of acrosstab query.
make sure you remove any "> " taht is just added in this
window.
Hope this helps.
Fons
 
Back
Top