Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
I have
EmployeeT
PhoneT
SectionT
I want to Count
How many employee in each Section? and
How many phone for each employee?
all of them in one Query
I tried to count the Section it works but If I add phone fields, I got wrong result
please help me!
Sample Attachment
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
I have
EmployeeT
PhoneT
SectionT
I want to Count
How many employee in each Section? and
How many phone for each employee?
all of them in one Query
I tried to count the Section it works but If I add phone fields, I got wrong result
please help me!
Sample Attachment