I need to count number of officers in route and the number of current officers onboard.
Table 1 is the Officers in route table.
Table 2 is the Current offices table.
I was using the Last Name fields to count number of current and in route officers.
ERROR 1: I can't use the =count([Last Name]) because access said there are more than one last name field to count.
ERROR 2: I can't use the =count([PG_tbl.Last Name])because access don't understand. Why won't this work????
Table 1 is the Officers in route table.
Table 2 is the Current offices table.
I was using the Last Name fields to count number of current and in route officers.
ERROR 1: I can't use the =count([Last Name]) because access said there are more than one last name field to count.
ERROR 2: I can't use the =count([PG_tbl.Last Name])because access don't understand. Why won't this work????
