SQL in Reports

[bstice]

Hello all,

I am fairly familiar with using SQL to pull information and dropping that in a form with a list box. I haven't used reports that much and I am curious if I can do the same thing. IE use SQL to create a query and then drop those results into a report. Ideally, I have about 4 or 5 SQL queries that I want to put into a report. Can this be accomplished? If so, how?

Here is an example of a SQL string that I want to put into a report with other queries:

str = "SELECT MasterAmericasActivity.[Workgroup Name-Rsrc], MasterAmericasActivity.[Level 4 Workgroup Name-Engg], Sum(MasterAmericasActivity.[SumOfCost Amt-US]) AS [SumOfSumOfCost Amt-US]" _
& "FROM MasterAmericasActivity GROUP BY MasterAmericasActivity.[Workgroup Name-Rsrc], MasterAmericasActivity.[Level 4 Workgroup Name-Engg], MasterAmericasActivity.[Accounting Period *]" _
& "HAVING (((MasterAmericasActivity.[Workgroup Name-Rsrc]) Like '*' & '" & aaindustryLst & "' & '*') AND ((MasterAmericasActivity.[Level 4 Workgroup Name-Engg]) not like 'Amer-Region') AND ((MasterAmericasActivity.[Level 4 Workgroup Name-Engg]) not Like '*' & '" & aaindustryLst & "' & '*') AND ((MasterAmericasActivity.[Accounting Period *])=aaaccountingperiod))" _
& "ORDER BY MasterAmericasActivity.[Workgroup Name-Rsrc];"

Thanks

Brennan

 

[HiTechCoach]

I normally use sub reports to sow data form different queries on the same report.