Cannot get Report to pull in Query Results

[mraetrudeaujr]

I am trying to recreate a report using the results of a new query. Before, this report relied on an extensive list of queries, and then would pull these into it. Now I have created an SQL query that is more efficient by doing the job of these 30 single queries.

I tried to use the 'code builder' to plug in the information for the 'control source' property, but it isn't working. What I have is a column on the left listing the "Stations" and then three more columns on the right that will contain the totals of three categories (VR, WA/NTA, and TOT) beneath the columns, that pertain to each "Station". The query name is "qryStationResults" and the column headings are; "VR" "WA/NTA" and "TOT". Also, there is a final column "Totals" and a final row "Totals". So how would this stack up on the Report 'control source' property sheet...assuming that this is where you would have the report look to? Any help is greatly appreciated. Thanks in advance.

 

[lespaul]

I think you can remove the TOTALS column and row from the query and just have the report calculate the totals. You may have a better response in the Access Reports Forum

Leslie

 

[mraetrudeaujr]

I looked for the "Reports" forum, but I didn't see it. That's why I posted it here. Thanks for the response, though.

 

[PHV]

http://www.tek-tips.com/threadminder.cfm?pid=703

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mraetrudeaujr]

PHV you came through again. Thanks. Also, I figured out what I was doing wrong and now my report works.