Missing info on reports

Maggie23

Registered User.
Local time
Today, 01:02
Joined
Jun 18, 2002
Messages
19
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 don't really understand exactly what you have for reports. At one point it sounds like you have one report and then all of a sudden you are saying (therefore two reports). Are you talking about seperate reports or mulitple records in a single report. The first thing to check is the address text box. Open the report in design view, click on the address textbox and open the properties box. Look for the Hide Duplicates property and make sure it is set to No. That may be the issue. Post back if it's not, but you might want to restate your problem.
Paul
 

Users who are viewing this thread

Back
Top Bottom