Creating a table from a recordset query then having a report form use the resulting table.

L

LordHog

Hello all,

I am building a report that pulls data from several different
databases on our network. I am using VBA/ADODB.Recordset to build the
queries based upon selections on a Form. I was finally able to build a
query that works and seems to pull in the data in the format I need,
but I am not sure how I get the resulting data to a Report Form. A
typical query might look like

SELECT lifecycle_phase, COUNT(lifecycle_phase) AS defect_cycle
FROM Defect
WHERE repoproject = 33554994 AND lifecycle_phase IN ( 'Planning',
'Requirements', 'Design', 'Coding', 'Integration', 'Verification' )
GROUP BY lifecycle_phase

which the result looks like

lifecycle_phase defect_cycle
Coding 35
Design 28
Integration 19
Planning 29
Requirements 25
Verification 25

So, my next hurdle is passing this data to a Report Form so I can
display it, something like

n |
. |
. | _
. | _ | |
1 | | | | |
----------------------------------
Planning Requirements ....

Any help is greatly appreciated.

Mark
 
Top