Showing queries in Reports

[digitalxni]

Hey Guys,

Now I know this should be a simple question but I'm having so much trouble with it. I've generated multiple queries and now I just need to form them into a report but I'm having trouble showing them on a report which is an unrelated object apparently. I started the report from scratch and started adding queries manually. But whenever I generated the report a popup box appears asking to "enter parameter value" and then in the report the textbox which should hold the query results shows '#NAME'. I've checked the queries and they all run perfectly fine. I'm guessing it's something to do with the report not being related to the tables/queries but I have no idea how about fixing it. Any solutions? I've tried using DCount on some other things instead of queries but they didn't seem to appear in the RTF file I exported from the report. Odd.

Just to add here is a link to a query from a textbox: =[TotalCarersRegistered].[CountOfCarerID]

 

[boblarson]

You can't do it that way. If you need data from more than one query, you need to either use a DLookup (slow, very slow) or sub reports.

 

[digitalxni]

So even though each query is returning me a single number I still have to use a sub report for every single query?

 

[boblarson]

So even though each query is returning me a single number I still have to use a sub report for every single query?

You can try using a DLookup but it usually is very slow. Why do you have a multitude of queries for a report? Is it really that you can't build a single query, or at least a few of them?

 

[digitalxni]

Most of them involve counting a single field and then grouping by whether a boolean field is true or a text box contains data so I suppose I could create a query that counts the single field then sub queries from that?