Question about White Space

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
J

Joe Cilinceon

What I have is a report that is listed by Tenant's names. They may have more
than one space so the report looks something like below:

John Smith 891 1/1/05 1/31/05
John Smith 900 1/1/05 1/31/05
Ken Toms 101 12/1/05 12/3105

Now what I would like to do is when the tenant name repeats (multiple units)
I would like it to just blank out as below:

John Smith 891 1/1/05 1/31/05
900 1/1/05 1/31/05
Ken Toms 101 12/1/05 12/3105

Is this possible with the report writer in Access XP and if so could someone
point me to how.
 
I did that but they may have multiple units. What happens is the tenant name
will print once as show below then adds the rest of the data in the detail
on a new line like below.

Joe Blow
123
456
Jack Black
123
etc

With it printing the name every line it takes 8 pages for the report, with
the method above it takes 32 pages. I can live with it though if it can't be
done. Thanks for the response PC.
 
Since a tenant may have multiple units, you have a one-to-many relationship
and yiur tables should look like:
TblTenant
TenantID
FName
LName

TblLease
LeaseID
TenantID
InDate
OutDate

For your report you then need a report/subreport where the main report is
based on TblTenant and the subreport is based on TblLease. To get the layout
you want, forget the grouping and put the subreport directly to the right of
the tenant field. Make the subreport one line high and set its Can Grow
property to True.
 
in report design view, try setting the Tenant Name control's HideDuplicates
property to Yes, and see if that will work for you.

hth
 
Joe said:
I did that but they may have multiple units. What happens is the tenant name
will print once as show below then adds the rest of the data in the detail
on a new line like below.

Joe Blow
123
456
Jack Black
123
etc

With it printing the name every line it takes 8 pages for the report, with
the method above it takes 32 pages. I can live with it though if it can't be
done. Thanks for the response PC.
Click to expand...


I prefer to avoid HideDuplicates, but it should work ok in
this particular situation.

To get the group header to print on the same line as the
first detail, add a line of code to the group header's
Format event procedure:

Me.MoveLayout = False
 
Back
Top