how to count registrys?

[Marcio]

Hello there,
I´m developing a Event Controler System.
I have a table where I record the data related to the event. I have a query that results in the events according to the site input.

I want to update this query that bring as results the total number of events done by a specific site....


Thanks in advance,
Márcio

 

[neileg]

Make this a totals query and use COUNT on the site name.

 

[Marcio]

Count Events

Thanks...
but it still doesn´t work.

Maybe because of my structure among tables..
The fact is that when I did what you told me to, as a result I have a number 1 placed in each event. I want to sum this 1´s.

Help meeeeeeeeeee...

thks a lot in advance,
Márcio

 

[EmmaJane]

Have you tried using Group by and then using a Expression to count each group

 

[neileg]

Thanks...
but it still doesn´t work.

Maybe because of my structure among tables..
The fact is that when I did what you told me to, as a result I have a number 1 placed in each event. I want to sum this 1´s.

Help meeeeeeeeeee...

thks a lot in advance,
Márcio

It's not clear if you understood what I meant. Here's a step by step.
Create your query in design view. Click the Σ button on the tool bar. This inserts a new line across the grid. This will say Group By in every column. In the column for the site name change Group By to Count.

If you need more help, we need more information, such as your table structure, the query structure, etc.