Forum Discussion
À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...
you need a "routine" that will save each "unit", "resident" into a separate record on a temp table.
then use this table as recordsource of your report.
then use this table as recordsource of your report.
Thank you
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.