Assuming your table with records to be counted has a userid field and is called TodaysWork:
Put this as the recordsource of a grid
Select userid, count(*) from TodaysWork group by userid
recordsourcetype = SQL statement
then issue thisform.myGrid.Requery when you want to update
HTH
Will
>Some help for that :
>I want to create a surveillance
screen and
not repo>I have : a table with names of users and a table with records wich I want to count
>The users may add records in that table,and in surveillance screen I want to have on line the number of record for each user.
>Thanks
>
>Dorin
Will Jones