Good Afternoon.
I have a table called enquiries, and within this table I have a field called person, date, year & complex (complex field just contains the numbers 1,2,3,4,5,6,7 & 8)
What I need to do is count all records in a query; against a person’s name for types 1,2,3,4,5,6,7 & 8, and return just the counts against that persons name.
An example would be:
So bob has: 9 1s for the year 2017
4 2s for the year 2017
5 3s for the year 2017
Any help would greatly be appreciated.
Kind Regards
Tor Fey
I have a table called enquiries, and within this table I have a field called person, date, year & complex (complex field just contains the numbers 1,2,3,4,5,6,7 & 8)
What I need to do is count all records in a query; against a person’s name for types 1,2,3,4,5,6,7 & 8, and return just the counts against that persons name.
An example would be:
So bob has: 9 1s for the year 2017
4 2s for the year 2017
5 3s for the year 2017
Any help would greatly be appreciated.
Kind Regards
Tor Fey