totals in forms

[grnfvr]

I am trying to create an expression in a text box that returns the number of records in a query. I have not had any success yet. I've written a total query which does return the count, but i need somehow to get that number to appear in the text box.

 

[RpbertS]

well if you have the total count value successfully captured in a query this should be relatively simple to solve.

First open the form in design view and double click the gray area under the form, click the data tab and click on the recordsource line (should be 1st) click the ... next to the line, now select the queries tab and add the query that stores that count information you want. once you do that click okay and you should see a list of fields in your query in the little box double click the right field and then you can close out of that if it asks you to save say yes. then create a field open up the properties go to the data tab and pick your field from the control source dropdown list

okay that should do it, sorry if I made it to simple

Rpb

 

[grnfvr]

Thank you for your response. Perhaps i wasn't explicit enough. I know how to do that. My problem is i want to return counts and sums from different sources onto the same form.