LOOP logo
Limitation of Oxidant Production: 
PIPAPO Database 

We found a calibration error in the PPD-Denuder measurements at Verzago.
All HNO2, HNO3, HCl, SO2, NO3-, NO2-, Cl- data have to be reduced by factor 2.24.
You can adjust the values in the database with a SQL routine as follows:

First: you have to copy the database on your harddisk.
Second: remove the write protection (by changing the corresponding attributes e.g. with the explorer by hitting the file and pressing the right mouse klick)
Third: Open the PIPAPO database within ACCESS, go to "Abfrage", click on "new", click on "Entwurfsabfrage" and then close the appearing pop-up window with the table.
Fourth: Click on SQL (upper left icon) then copy and paste the following SQL string

UPDATE Measurements SET Measurements.[Value] = [Measurements]![Value]/2.24

WHERE (([Measurements]![Record_ID]>=214 And [Measurements]![Record_ID]<=221));

instead of the select command and then click on the execute icon.



Last updated by Albrecht Neftel on January 10, 2001 

home Home