Skip line in report when BuildingNumber field changes

[Ed Dobbin]

Hi folks:
In the detail section of my report I have the following
fields:
FileNum BuildingNum BuildingName Sub-BuildingName
Location TotalArea ReplacementCost.

I was wondering if it is possible to add code (or easier
way) that would skip a line (or insert a blank line) when
the BuildingNum field changes.

By the way a big thank you to Nikos who helped me a
couple of weeks ago to number each detail record and
reset the number based on the Region field. Hats off to
you Nikos. Thanks.
Ed

 

[Marshall Barton]

Hi folks:
In the detail section of my report I have the following
fields:
FileNum BuildingNum BuildingName Sub-BuildingName
Location TotalArea ReplacementCost.

I was wondering if it is possible to add code (or easier
way) that would skip a line (or insert a blank line) when
the BuildingNum field changes.

That would be easy to do if you group on the building num
field. Then the group footer could provide the blank line.

 

[Ed]

It's a little more complicated than that Marsh. The
fields I have in the detail section need to stay there
because of the code and formatting in the output report.
That's why I wanted to simply try some code. when I
grouped on BLDGNUM and inserted the BLDGNUM Footer it
still spaces each line the same distance .
Ed

 

[Steve Schapel]

Ed,

PMFJI here. I think what Marsh had in mind was to leave the BLDGNUM
Footer blank, but set the height of the section to the same as the
height of one of your Detail records, with the effect of simulating a
blank row at the end of every set of BLDGNUMs. Isn't that what you want?

 

[Marshall Barton]

I don't understand. The details within a bldgnum will be
spaced as specified in the details section. The bldgnum
group footer can have as much space as you want between
bldgnums.

Maybe I need to see a brief example of what you're getting
and what you want.

 

[Guest]

Yes I just want a function that says if BLDGNUM changes
then insert a blank row before starting next BLDGNUM.
I now have:

SheetNUM BLDGNUM BUILDING NAME LOCATION AREA Replacement$
1 1227 Sanitorium St John's $$$$$
2 Shed $$$$$
3 1228 CONA Campus Bell Island $$$$$
4 Sub-Building1 St. John's $$$$$
5 1229 Quanset Hut Pleasantville $$$$$

I want this:
SheetNUM BLDGNUM BUILDING NAME LOCATION AREA Replacement$
1 1227 Sanitorium St John's $$$$$
2 Shed $$$$$

3 1228 CONA Campus Bell Island $$$$$
4 Sub-Building1 St. John's $$$$$

5 1229 Quanset Hut Pleasantville $$$$$
without moving the controls into another group.
Sorry if it sounds confusing.
Ed

 

[Steve Schapel]

Ed,

No, it's not confusing... I think I (and Marsh) both understand clearly
what you want. The only confusing aspect is why you don't use the
method that has been suggested, ihn order to achieve what you want. To
re-iterate...
- don't move any controls anywhere.
- if you don't already have a BLDGNUM Footer section, use the report's
Sorting and Grouping dialog to put one in, leave it (the footer section)
blank, but make it as high as one of the detail records.
- if you do already have a BLDGNUM Footer section, put a blank space,
about as high as one of the detail records at the top of the section.

Sorry if I'm missing the point here, but at this stage I can't see why
this is not a good solution.

 

[Marshall Barton]

Yes I just want a function that says if BLDGNUM changes
then insert a blank row before starting next BLDGNUM.
I now have:

SheetNUM BLDGNUM BUILDING NAME LOCATION AREA Replacement$
1 1227 Sanitorium St John's $$$$$
2 Shed $$$$$
3 1228 CONA Campus Bell Island $$$$$
4 Sub-Building1 St. John's $$$$$
5 1229 Quanset Hut Pleasantville $$$$$

I want this:
SheetNUM BLDGNUM BUILDING NAME LOCATION AREA Replacement$
1 1227 Sanitorium St John's $$$$$
2 Shed $$$$$

3 1228 CONA Campus Bell Island $$$$$
4 Sub-Building1 St. John's $$$$$

5 1229 Quanset Hut Pleasantville $$$$$
without moving the controls into another group.
Sorry if it sounds confusing.

We must be miscommunicating somewhere along the line here.

No one ever suggested that you should move any controls
anywhere. Just create a group with footer on the bldgnum
field. Then set the (blank) group footer section to however
tall you want the blank space to be. This is a trivial
thing to do and should not mess up anything you've already
told us about.
--
Marsh
MVP [MS Access]

 

[Guest]

Yes thanks. I fully understand what you are saying. It's
just when I tried that, the blank line was inserted
between every row like this for some funny reason:
I don't have access to the database right now to try
anything else until tomorrow. Not to worry though, thanks
guys, till later.
Ed

-----Original Message-----

Yes I just want a function that says if BLDGNUM changes
then insert a blank row before starting next BLDGNUM.
I now have:

SheetNUM BLDGNUM BUILDING NAME LOCATION AREA Replacement$
1 1227 Sanitorium St John's $$$$$
2 Shed $$$$$
3 1228 CONA Campus Bell Island $$$$$
4 Sub-Building1 St. John's $$$$$
5 1229 Quanset Hut Pleasantville $$$$$

I want this:
SheetNUM BLDGNUM BUILDING NAME LOCATION AREA Replacement$
1 1227 Sanitorium St John's $$$$$
2 Shed $$$$$

3 1228 CONA Campus Bell Island $$$$$
4 Sub-Building1 St. John's $$$$$

5 1229 Quanset Hut Pleasantville $$$$$
without moving the controls into another group.
Sorry if it sounds confusing.

We must be miscommunicating somewhere along the line here.

No one ever suggested that you should move any controls
anywhere. Just create a group with footer on the bldgnum
field. Then set the (blank) group footer section to however
tall you want the blank space to be. This is a trivial
thing to do and should not mess up anything you've already
told us about.
--
Marsh
MVP [MS Access]

leave
the BLDGNUM of
simulating a

.