Load Form and Update Table

[twosides]

Hi Folks,
Does anyone know how I would count the records in a table (called STAFF) for a given date and then add a flag if the count was over say 20 from a form?

Cheers

 

[SteveSchapel]

Twosides,

I don't know what you mean by "add a flag". But if I understand the other part of the question correctly, you will be looking at code like this:

If DCount("*", "Staff", "YourDateField = Date()") > 20 Then
    ' your flag raising ceremony here
End If

 

[MarkK]

Laughing ...

'your flag raising ceremony here

I think that's pretty funny.

 

[SteveSchapel]

Re: Laughing ...

gratifying to know I have been able to spread a little merriment.

 

[twosides]

Cheers for the reply.
Yes I agree its funny. Made me smile at 06.45 am in the UK !!
How could I do the count for each date value in turn?
To be fair the TrainDate tavle is a one to many with the Staff table so I do have a DateRef field in the Staff table; so this could be counted I guess. But how would I code it so it counts all the '1' values and then activates the 'flag raising ceremony' for the coresponding record in the TrainDate table. Then proceeds to do it for the next value of DateRef ie '2' ?
Thanks