Report setup

  • Thread starter Thread starter Mariah
  • Start date Start date
M

Mariah

We have several members living at each address, but they move around
independantly of each other.

I have been asked to create one report (order form) per member address that
would contain the names of everyone in the household on a single form. I
currently have a customer address table based on each member as a record. I
could simply concatenate, but I need the names to appear in a vertical row
with blank lines next to the name so they can order directories.

Before I work with this any further I thought it would be best if I sought
your advice regarding setup. For example, am I going to have to create a new
table where the record is based on address?

Any help is deeply appreciated. Happy Holidays!
 
If you have a table of members and a table of addresses and they have fields
that can link the two together, then all you need is to create a query that
joins the tables on the the common field(s) and use that as the recordsource
for your report.

Then use Sorting and Grouping to group by address. The in the group
header, set the force new page to Before Section. That will give you a
separate report for each address.
 
Thank you so much, this information is easy to follow and will make this
report a success.

Have a very happy new year!
 
Back
Top