query bound text box?

[tlove161]

I have a report that is grouped by two fields; County then Grantee. Each grantee can conduct four types of events. The report is based on a query that shows all the events the grantees conducted.

I have created four queries that count the four types of events the grantees conducted. I created four unbound text boxes on my report that I want to fill with the four queries. Is this possible?

I tried using dlookup, but it put the first grantee's value in all the text boxes for that event type.

What do I need to put in the control source of the four text boxes? Thanks.

 

[kmclane]

Try joining the four queries to the main query, then add the fields you want to show.
Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg