I want to produce a report linked to query. The query will link to tables, one called contact the other notes. The contact table holds customer info address etc and what I wish to do is bring the notes table info into the same report.
The notes table has a date field, subject field & notes. The notes section holds all the information on customer contacts in date order. What I am trying to achieve is a single A4 sheet per customer that lists the customer details and all contact history notes, then move onto the next customer for another single A4 sheet.
Can anyone help? [sig][/sig]
The notes table has a date field, subject field & notes. The notes section holds all the information on customer contacts in date order. What I am trying to achieve is a single A4 sheet per customer that lists the customer details and all contact history notes, then move onto the next customer for another single A4 sheet.
Can anyone help? [sig][/sig]