Jaydub1991
New member
- Local time
- Today, 11:08
- Joined
- Sep 21, 2021
- Messages
- 10
Morning all,
My Data base is comprised of Tables which is organised by "Clients" and within these fields is a checkbox column. I am looking to calculate all the ticked boxes for each client.
Clients are separated by a GroupID but all reside in one Table. very basic view of it below ( there are more fields but they are irrelevant)
I would like the total for each Clients tickboxes displayed on a seperate form which makes up part of the menu for my database.
I am very very very basic with Access Databases and had the assistance of another to put this database together so please go easy on me!
Ta
James
My Data base is comprised of Tables which is organised by "Clients" and within these fields is a checkbox column. I am looking to calculate all the ticked boxes for each client.
Clients are separated by a GroupID but all reside in one Table. very basic view of it below ( there are more fields but they are irrelevant)
GroupID | Customer Name | File Closed |
Client 1 | Smith | Tickbox |
Client 2 | Jones | Tickbox |
Client 1 | Bob | Tickbox |
Client 3 | Davies | Tickbox |
Client 2 | Albert | Tickbox |
Client 3 | Peters | Tickbox |
I would like the total for each Clients tickboxes displayed on a seperate form which makes up part of the menu for my database.
I am very very very basic with Access Databases and had the assistance of another to put this database together so please go easy on me!
Ta
James