I'm trying to figure out maybe a simple problem. I need to create a kind of attendance tracker and use as field of one table, records from another one.
Example:
TABLE A WHERE I HAVE ALL NAMES OF USERS
| NAME | INFO |
|---|---|
| Name 1 | detail 1 |
| Name 2 | detail 2 |
TABLE B WHERE I STORE FOR EVERY DAY WHO IS THERE OR NOT
| DATE | Name 1 | Name 2 | Name [...] |
|---|---|---|---|
| 01/01/2024 | YES | YES | ---------- |
| 02/01/2024 | NO | YES | ---------- |
I mean, I don't know if this can be possible using access or not, I've already done with the table A imported from excel but I really can't find a solution to generate as many fields as the records of the first table
Step 1. Transpose table B
Step 2. Let's remove redundancy. Let's leave only those who were present
Step 3. column "Presence" is no longer needed. We indicate the names of only those who were present