M mwgo Guest Jun 1, 2000 #1 I need to count the occurence of a field (I.e how many employees) from a employeeID (this I can do in a query) and then copy the value to a forms field or the underlying table field? Any Ideas?
I need to count the occurence of a field (I.e how many employees) from a employeeID (this I can do in a query) and then copy the value to a forms field or the underlying table field? Any Ideas?
M MattGilbert Registered User. Local time Today, 20:58 Joined Mar 24, 2000 Messages 12 Jun 2, 2000 #2 You could use DCount. There are examples in the help files. This should do the trick! [This message has been edited by MattGilbert (edited 06-02-2000).]
You could use DCount. There are examples in the help files. This should do the trick! [This message has been edited by MattGilbert (edited 06-02-2000).]