Forum Discussion
Access and joining rows columns and fields
Hello boys and girls! I have some riddle to solve, and I hope I'll find some help... I have two tables, one personel (like I'd, number, f.name, s.name) and second doc(like I'd, title, related, attac...
Hi Ttsz1
If I understand your request correctly, it would be quite complicated to achieve this and require some significant VBA programming with dynamic field arrays or a comparable solution. Therefore, I'm wondering if Excel could fulfill your request since a spreadsheet has the column/row structure you'll need and adding a person or doc only means adding a row or column. The intersecting cells for persons and docs then contain the yes/no values.
Just a thought.