I created a query which displays the persons currently on vacation leave I would like to count the number of persons on vacation.
The fields being used are Date From, Date To, Name, Type Leave
I created a query which displays the persons currently on vacation leave I would like to count the number of persons on vacation.
The fields being used are Date From, Date To, Name, Type Leave
In what situation? One way would be a DCount() on the query:
DCount("*", "QueryName")
You could try...
dim x as Integer
x= DCount("*","yourqueryname")
'MsgBox x
Hope this helps.
Jim
I didn't see Paul's reply before I posted in a duplicate fashion.
Jim
No problem Jim.