View Single Post
  #5 (permalink)  
Old July 30th, 2007, 09:52 AM
Odeh Naber Odeh Naber is offline
Authorized User
Join Date: Mar 2006
Location: , , .
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts

Thank you so much for your reply!

This worked beautifully, Ashfaque.

I went further one step:

I named the unbound text box that you mentioned in your post "txtCounter". Then I added a group footer for Categories, and added an unbound textbox. The control source for this new unbound textbox is =[txtCounter]. The result when I go to "Report View" always shows me the count in that category. Perfect!

The problem I have now is how can I use this result in a formula that exists in another field? This is the main reason I need the count.

Thank you!