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.
- As is too often the case, a work-around that doesn't address the inappropriate table design is at best a work around that perpetuates the problems inherent in trying to work with inappropriate, non-relaxational table designs. Reliance on code "routines" to compensate for inappropriate table design may appeal to the desire for a short-term solution, but it is almost never a useful long-term response.
In other words, the OP does not "need" to implement this workaround. The OP could avoid the hard work of designing a proper relational database application, but that is not satisfying the underlying need.
