Form to display query results

[kpdog9]

I created a query to pull data from a table of Towns and Quests...each town has multiple quests. The query tallys these correctly, but I want to display the individual results on my form. For Example I want a text box to show that shows 1 town and the number of quests for that town. In otherwords set the textbox equal to a field in Column, Row.

 

[AlexMidd]

SELECT Count(Quests.QuestID) AS CountOfQuestID, Towns.TownID
FROM Quests
GROUP BY Quests.TownID;

Have fun! )

Alex Middleton

 

[kpdog9]

Will that allow me to pull data say only from cell C4 from my query?

Also how do I use code...do I just put that in the Control Source?