I have a problem!
I have a table, tbl_Members.
tbl_Members contains many fields, two being SName and RefferedBy.
ReferredBy is stored in the table from a lookup from a form that looks up the SName field from tbl_Members.
What i want to do is create a query from this table with an extra field which counts the number of instances based on the records SName, in a field called NoReffers.
For example, i want a query that looks like:
qry_tbl_Members:
-----SName-----ReferredBy-----NoReffers---
-----Bloggs--------Hills-------------1-------
------Hills--------Barnard-----------2-------
-----Smith--------Bloggs----------- 0------
----Truman--------Hills-------------1------
---Williamson-----Truman-----------0------
I 've been looking into the Count() function, but cant seem to work it out!
Can someone help me?
I have a table, tbl_Members.
tbl_Members contains many fields, two being SName and RefferedBy.
ReferredBy is stored in the table from a lookup from a form that looks up the SName field from tbl_Members.
What i want to do is create a query from this table with an extra field which counts the number of instances based on the records SName, in a field called NoReffers.
For example, i want a query that looks like:
qry_tbl_Members:
-----SName-----ReferredBy-----NoReffers---
-----Bloggs--------Hills-------------1-------
------Hills--------Barnard-----------2-------
-----Smith--------Bloggs----------- 0------
----Truman--------Hills-------------1------
---Williamson-----Truman-----------0------
I 've been looking into the Count() function, but cant seem to work it out!
Can someone help me?