Getting query data for a report

  • Thread starter Thread starter RussCRM
  • Start date Start date
R

RussCRM

If I have the query "UniqueCounts" and following query results:

Count ServicesType
2 Food Basket
99 Men's Dorm
84 Personal Needs
5 PN Family Pack
14 Program Dorm
7 Temporary ID


What would I put in a text field in a report to get the query results
from Count for the ServicesType "Men's Dorm". (Which should be the
value 99.)

Thanks!
 
you would want to put in 'Men's Dorm' as the criteria in the query....on in
a new query that is applied to this query

that will create a query with just your one record.

I don't quite follow your question on what to 'put in the text field'
because in Reports one can not put in any data - they are passive...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning data into field heading, similar to a pivot table 7
Crosstab Report's subreport 1
Report Error for certain Crosstab Query 2
Reports Grouping 4
Limit results on report 9
how do i rank on report 1
Using select and crosstab queries on one report 1
Complicated expression in a report for a query 1

Back
Top