Display the results of a count query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that is counting records in a table. I want to be able to
display the results of that query on a form. I tried using an unbound text
box and the expression builder, but nothing displays. The expression builder
created a formula in the Before Update properties field

=[Members Total Count Query]![CountOfLastName]

I know it is possible....
 
You could create a form for the count query, which I assume is producing a
single result, and then embed the form as a sub-form in a master form.
Another alternative is a dlookup, but that can slow down your access time to
data, as it must recalc each time you move to a new record.
 
Back
Top