Number of Items

[leecsone]

HI


I have a report with ten names. I need the report tol show me that I have ten names on a report? And every time I add a name the number will advance to the next number. What I am trying to do is have the names of a report on the form and at the end of the name will be the number of names on that report. I have created a form that will keep record of how many people are using a particular item.

Thank you
leecs
leecs@northrock.bm

 

[dcx693]

Use the count function in an unbound text field in your report or group footer.

 

[leecsone]

Count number of items

HI dcx693


Thank you for your help. It's works fine.

I have other question for you. The count number is on a report how can I print a report without printing the number. I have the number in the header. Or better jet how can I get the count number of items on a form next to the name of the report. So I can see how many items I have on the report befor I open the report to view it.


Thank You
leecsone
leecs@northrock.bm

 

[dcx693]

The easiest way to get that number on a form next to the name might be using the DCount function. It's slow, but it handles small tasks like that.