Group count doesnt work

K

Kelly

I am trying to count how many tickets each employee sold. I have a staff
header with the employee name. Then I have detail that shows the ticket
numbers sold by that staff member. Then I have a staff footer where I am
trying to count the tickets from the detail, but it doesn't work. I made a
text box, put it in the staff footer and this is the control source. (I
found it in my Dummies book)

count([ticket number])

When I go to run it I get an error. Any suggestions?
 
A

Allen Browne

The expression in the Control Source of the text box needs to start with =.
Try:
=Count([ticket number])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Using <= in countifs statement 1
Show if record count more than 4
Creating a printable raffle ticket with serial numbers 0
Select Text to End of Footnote 9
Getting Radio Buttons to work, that are inserted via AutoText 0
Using Microsoft Access as a Service Ticket Write-up program 0
A03 - count in report footer gives me #Error? 0

Top