Forum Discussion
Ansiep1
Jul 21, 2022Copper Contributor
Àccess Reports
I have a Residents Table which includes Units (with their ID) with two or three Residents (Each with their separate IDs). How do I create a Report displaying Initials and Surnames per Unit? i.e. Unit...
Ansiep1
Jul 22, 2022Copper Contributor
Thank you
arnel_gp
Jul 22, 2022Iron Contributor
i made a sample for you to understand.
there are 2 tables, one is "normalized" called proper table.
the other is, i am guessing, what you have, non-normalized, improper table.
then i made reports for each table..
the improper report calls a Public function to separate each unit, resident to each row.