Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Surveillance screen
Message
From
04/04/2002 07:05:01
 
 
To
04/04/2002 06:22:07
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00640766
Message ID:
00640783
Views:
13
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform