I'm a real novice with access & help would be appreciated.
I created a report from a query of two tables. When I run the report if I have one client with two records (therefore two reports) it prints the address on the first with all the details correctly but on the second it only prints the details - no address appears. The address comes from one table, the details from another.
To make table entries I enter the names through one form for the client table. The second table records come from a form with a subform. The main form allows me to pull up the correct client, the subform part is where I enter the details for the detail table.
How do I make the address show on every report?
Thanks for any and all help.
I created a report from a query of two tables. When I run the report if I have one client with two records (therefore two reports) it prints the address on the first with all the details correctly but on the second it only prints the details - no address appears. The address comes from one table, the details from another.
To make table entries I enter the names through one form for the client table. The second table records come from a form with a subform. The main form allows me to pull up the correct client, the subform part is where I enter the details for the detail table.
How do I make the address show on every report?
Thanks for any and all help.