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.
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.
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.