Access query into pseudo code

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hello all,

I am not an Access user but I am having to convert a badly written VBA
interface which pulls information from a database. It uses the
following query and I can't work out exactly what it does. Could
someone help me out here?

SELECT tbl_SourceCellAssoc.cell_id,
Sum(tbl_SourceEmissionAssoc.factor1*tbl_SourceEmissionAssoc.factor2*tbl_hourlyactivity.coefficient*tbl_SourceCellassoc.fraction*tbl_emission.nox)
AS NOX,
Sum(tbl_SourceEmissionAssoc.factor1*tbl_SourceEmissionAssoc.factor2*tbl_hourlyactivity.coefficient*tbl_SourceCellassoc.fraction*tbl_emission.co)
AS CO,
Sum(tbl_SourceEmissionAssoc.factor1*tbl_SourceEmissionAssoc.factor2*tbl_hourlyactivity.coefficient*tbl_SourceCellassoc.fraction*tbl_emission.hc)
AS HC,
Sum(tbl_SourceEmissionAssoc.factor1*tbl_SourceEmissionAssoc.factor2*tbl_hourlyactivity.coefficient*tbl_SourceCellassoc.fraction*tbl_emission.sox)
AS SOX,
Sum(tbl_SourceEmissionAssoc.factor1*tbl_SourceEmissionAssoc.factor2*tbl_hourlyactivity.coefficient*tbl_SourceCellassoc.fraction*tbl_emission.pm10)
AS PM10, First(qry_3DGridCells.X) AS X, First(qry_3DGridCells.Y) AS Y,
First(qry_3DGridCells.H) AS H INTO tbl_EmisResults
FROM tbl_QueryPeriod, qry_3DGridCells INNER JOIN ((tbl_Emission INNER
JOIN (tbl_SourceEmissionAssoc INNER JOIN tbl_SourceCellAssoc ON
(tbl_SourceEmissionAssoc.dynamics_id=tbl_SourceCellAssoc.dynamics_id)
AND (tbl_SourceEmissionAssoc.source_id=tbl_SourceCellAssoc.source_id)
AND (tbl_SourceEmissionAssoc.source_id=tbl_SourceCellAssoc.source_id)
AND
(tbl_SourceEmissionAssoc.dynamics_id=tbl_SourceCellAssoc.dynamics_id))
ON tbl_Emission.emis_id=tbl_SourceEmissionAssoc.emis_id) INNER JOIN
tbl_HourlyActivity ON
tbl_SourceEmissionAssoc.hourprofile_id=tbl_HourlyActivity.hourprofile_id)
ON qry_3DGridCells.cell_id=tbl_SourceCellAssoc.cell_id
WHERE (((tbl_HourlyActivity.hour)>=[start_hour] And
(tbl_HourlyActivity.hour)<=[end_hour]))
GROUP BY tbl_SourceCellAssoc.cell_id;

It has me stumped. Can someone please explain this or translate that
into pseudo code?
 
Have you tried entering the SQL into the query design window in SQL view,
with a trailing ";" and then converting it to the normal query design view?

It is a complex group by query, but if Access can handle it, it will be a
lot clearer viewed like that.
 
Back
Top