problem displaying data in report

[dreamweaver547]

Hi,

I have created a query relating to extracting data:

 
SELECT Count(Output.Source) AS CountOfAPPROACH_CODE
FROM [Output]
WHERE (((Output.Source)=60681));

I have also created another query for source codes 60682 and 60683.

When I use the report wizard I get 3 seperate reports for each number, but this is no good.

A semi-solution is to do a UNION query and create a report from that:

SELECT Count(Output.Source) AS CountOfAPPROACH_CODE
FROM [Output]
WHERE Output.Source=60681
UNION
SELECT Count(Output.Source) AS CountOfAPPROACH_CODE
FROM [Output]
WHERE Output.Source=60682
UNION SELECT Count(Output.Source) AS CountOfAPPROACH_CODE
FROM [Output]
WHERE Output.Source=60683;

but then I cannot adjust the text box to add additional information around this.

This does not seem to work manually through the expression builder with two text boxes referring to different queries. I get an

#Error

message if I try to change things in the control source of the second text box.

Any ideas?


Thanks

[weekend00]

one query is enough:
SELECT output.source,Count(Output.Source) AS CountOfAPPROACH_CODE
FROM [Output]
WHERE Output.Source in (60681,60682,60683) group by output.source

[NTC]

well a Report has a record source. i.e. a query - that query in turn typically has multiple records.

the native layout of all dbs is that the records will show stacked , linear - so depending on the layout of the report they could be all on one page, or on separate pages but still conceptually linear.

an attempt to go horizontal layout means either using crosstab techniques...or making separate individual subreports, each with their own record source - and then inserting them into a main report that serves the purpose of simply gathering together the subreports.

hope this helps.

[dreamweaver547]

OK, but I'm still having problems with this in report form.

I'm unable to split up the figures with three different new labels as the report will show me the same label for the three source figures.

How could I have a different label for each source figure, ie. 60681,60682 and 60683?

[dreamweaver547]

Got the above reply as I was replying to the first. A 3 minute delay...

an attempt to go horizontal layout means either using crosstab techniques...or making separate individual subreports, each with their own record source - and then inserting them into a main report that serves the purpose of simply gathering together the subreports.

Could you explain to me how I could do this?