I have a report that creates confirmation letters to send to customers when they update their phone number.
It gets data from a table using a query that is called from autoexec.
The design of the report and the table is simple:
Date
Name
Address
Phone Type
Old number
New number
If a user changes more than one number (cell, home, business) at a time there are then multiple rows in the table, and the information is sent out in multiple letters. My managers used to be fine with multiple letters going out to the same customer in a day, but now they would like it to all be in one letter.
Is there a way to use data in a report from a query that returns more than 1 row as follows?
Date
Name
Address
Phone Type
Old number
New number
Phone Type
Old number
New number
Phone Type
Old number
New number
Thank you!