report format

  • Thread starter Thread starter subs
  • Start date Start date
S

subs

ocity ozip dcity dzip consignee
a b c d clo
e f c d clo
l k c d clo
t s m k mto


this is the format i have in a access report- i want to convert the
above format into the format below--- how do i get the format below?
c,d, clo is common to first three rows. so i want to have that row in
the middle of first three rows like below and also have a dividing
line after ozip for such pattern of data. Is there a way to automate
it. Thanks

ocity ozip dcity dzip consignee
a b
e f c d clo
l k
t s m k mto
 
I expect you could create a sorting and grouping level on the combination of
dcity, dzip, and consignee. Add a text box in the group header that counts
the records in the group. Add a text box in the detail section
Name: txtCountGroup
Control Source: =1
Running Sum: Over Group
You would then need to add code to the On Format event of the detail section
that would hide the three controls if the the value of txtCountGroup wasn't
equal to the Count/2 rounded up.
 
Back
Top