Using multiple queries in a report

[clickster]

I have a table with about 40-50 Yes/No fields. For each field I have a query that counts the total number of records that have Yes checked under each field. The queries work great. But I can't seem to find a way to create a report that lists the values of all of the queries. I simply want a page that has a text box for each field and that displays the count (from the corresponding query) of each field. If I use the wizard, it will let me do this for one field only. If I try to add the value of more than one query to the report, it won't let me. I have tried using design view and puting a bunch of text boxes with each one pointing to the <value> in the corresponding query, but the text boxes just show #name. Any help would be great. Thanks

 

[GoDawgs]

Look up the Dsum and Dlookup functions, if you put these into your text boxes you can actually pull values from queries/tables that aren't in your report recordsource. Not sure what the exact answer should be, but hopefully this gets you going in the right direction.

Kevin

 

[mikey69]

You should remember that yes in Access-speak has a value of -1, so if you construct a querty with all the yes-no boxes in it and use the sum button, you'll get the total of -1's. multiply this by -1 in each case and you have what I think you need.