Grouping by first two digits of a project number

[Guest]

I created a database to keep track of projects. The projects each have their
own four digit project number, the first two numbers of which represent the
year of the project. I want to print a report that has blank space after each
year's projects. I read that you can put some blank space in a group footer.
How can I create groups based on the first two numbers of each project number?

I don't know if this complicates it, but the report is not sorted by the
project number. Many of them were before 2000 (so they start with numbers
78-99) and now the ones after 2000 start with 00-07, so I had to make another
field for primary key numbers, to sort by those and then just hide the
column. The number field is also a text field instead of a number field
because some of the project numbers have A or B at the end.

 

[Guest]

Nevermind.
Of course, I only figured it out after I asked. =]

But I still can't see how to add the blank space? I have a report header and
footer, a page header and footer, and a group header, but no group footer.

 

[Larry Linson]

Nevermind.
Of course, I only figured it out after I asked. =]

But I still can't see how to add the blank space? I have
a report header and footer, a page header and footer, and
a group header, but no group footer.

Easy way: add a group footer with nothing in it but the space you want to
follow a year's data.

On the other hand, if you want the records sorted so that dates are
intermixed, how can you possibly "leave a blank between years"? By
extracting the year code, and grouping by it, you will automatically have a
high level sort by date, but within a year, you can sort on any other field
you wish.

Larry Linson
Microsoft Access MVP

 

[Guest]

That's the problem, I can't find a way to add a group footer.

And sorry, I didn't explain that very well. The records ARE in order by
date, but if I simply sorted by the project number column, it would place the
00-07 projects above the 78-99 projects. But that's ok, because I got the
groups all sorted out. All that's left is to create a footer.

Nevermind.
Of course, I only figured it out after I asked. =]

But I still can't see how to add the blank space? I have
a report header and footer, a page header and footer, and
a group header, but no group footer.

Easy way: add a group footer with nothing in it but the space you want to
follow a year's data.

On the other hand, if you want the records sorted so that dates are
intermixed, how can you possibly "leave a blank between years"? By
extracting the year code, and grouping by it, you will automatically have a
high level sort by date, but within a year, you can sort on any other field
you wish.

Larry Linson
Microsoft Access MVP

 

[tina]

open the report in Design view. open the Sorting and Grouping box and click
on the field/expression that you want to add a footer section to. in the
GroupProperties section at the bottom, change the GroupFooter property to
Yes.

hth

That's the problem, I can't find a way to add a group footer.

And sorry, I didn't explain that very well. The records ARE in order by
date, but if I simply sorted by the project number column, it would place the
00-07 projects above the 78-99 projects. But that's ok, because I got the
groups all sorted out. All that's left is to create a footer.

Nevermind.
Of course, I only figured it out after I asked. =]

But I still can't see how to add the blank space? I have
a report header and footer, a page header and footer, and
a group header, but no group footer.

Easy way: add a group footer with nothing in it but the space you want to
follow a year's data.

On the other hand, if you want the records sorted so that dates are
intermixed, how can you possibly "leave a blank between years"? By
extracting the year code, and grouping by it, you will automatically have a
high level sort by date, but within a year, you can sort on any other field
you wish.

Larry Linson
Microsoft Access MVP

 

[Guest]

It came out just right, thank you.

open the report in Design view. open the Sorting and Grouping box and click
on the field/expression that you want to add a footer section to. in the
GroupProperties section at the bottom, change the GroupFooter property to
Yes.

hth

That's the problem, I can't find a way to add a group footer.

And sorry, I didn't explain that very well. The records ARE in order by
date, but if I simply sorted by the project number column, it would place the
00-07 projects above the 78-99 projects. But that's ok, because I got the
groups all sorted out. All that's left is to create a footer.

Nevermind.
Of course, I only figured it out after I asked. =]

But I still can't see how to add the blank space? I have
a report header and footer, a page header and footer, and
a group header, but no group footer.

Easy way: add a group footer with nothing in it but the space you want to
follow a year's data.

On the other hand, if you want the records sorted so that dates are
intermixed, how can you possibly "leave a blank between years"? By
extracting the year code, and grouping by it, you will automatically have a
high level sort by date, but within a year, you can sort on any other field
you wish.

Larry Linson
Microsoft Access MVP

 

[tina]

you're welcome

It came out just right, thank you.

open the report in Design view. open the Sorting and Grouping box and click
on the field/expression that you want to add a footer section to. in the
GroupProperties section at the bottom, change the GroupFooter property to
Yes.

hth

That's the problem, I can't find a way to add a group footer.

And sorry, I didn't explain that very well. The records ARE in order by
date, but if I simply sorted by the project number column, it would

place
the

00-07 projects above the 78-99 projects. But that's ok, because I got the
groups all sorted out. All that's left is to create a footer.

:



Nevermind.
Of course, I only figured it out after I asked. =]

But I still can't see how to add the blank space? I have
a report header and footer, a page header and footer, and
a group header, but no group footer.

Easy way: add a group footer with nothing in it but the space you

want
to

follow a year's data.

On the other hand, if you want the records sorted so that dates are
intermixed, how can you possibly "leave a blank between years"? By
extracting the year code, and grouping by it, you will automatically have a
high level sort by date, but within a year, you can sort on any

other
field

you wish.

Larry Linson
Microsoft Access MVP