Calculated Formula Field

[SantasLittleHelper]

I have 2 tables:
Table 1 - Holds all of the data about companies
Table 2 - Holds all of the staff names in my company

Is there a way to create some sort of calculation which shows:
Total Distinct values in 'FieldX' (Table 1) where 'StaffMember' (Table 1) is equal to 'StaffMember' (Table 2)

Ideally, I would have a field in Table 2 called 'TotalAllocated' which displays the number next to their record.

Does anybody have any ideas?

 

[ranman256]

How can they match?
tbl1= other companies,
tbl2= your staff.

you can count them in 2 qrys.
Q1 count table1
Q2 count table2
Q3, put them together.