Subheaders

[golfinray]

I have a report built to show year one projects, then subcategory of space
projects and repair projects. I also have budgets for each project, each
category (repair and space), Grand Total, and then an overall running sum.
My year one projects id#s start with 1112, year two with 1213. I can't figure
out how to get a label for year one and year two. It puts year one and year
two on year one projects and year two projects. I have grouped on project
year and project category (space or repair.) Thanks!!!

 

[KARL DEWEY]

Can you not just use Left([ProjectID],4) AS [Project Year] and group on
that?

 

[golfinray]

That didn't do it for some reason.
--
Milton Purdy
ACCESS
State of Arkansas

Can you not just use Left([ProjectID],4) AS [Project Year] and group on
that?

--
Build a little, test a little.

I have a report built to show year one projects, then subcategory of space
projects and repair projects. I also have budgets for each project, each
category (repair and space), Grand Total, and then an overall running sum.
My year one projects id#s start with 1112, year two with 1213. I can't figure
out how to get a label for year one and year two. It puts year one and year
two on year one projects and year two projects. I have grouped on project
year and project category (space or repair.) Thanks!!!

 

[Duane Hookom]

Milton,
You have hung out in these news group long enough that you should understand
that "That didn't do it for some reason" doesn’t cut it for some reason.

If you want some assistance, kick it up a notch and provide good
information, results, attempts, specs, ...

--
Duane Hookom
MS Access MVP

That didn't do it for some reason.
--
Milton Purdy
ACCESS
State of Arkansas

Can you not just use Left([ProjectID],4) AS [Project Year] and group
on
that?

--
Build a little, test a little.

I have a report built to show year one projects, then subcategory of
space
projects and repair projects. I also have budgets for each project,
each
category (repair and space), Grand Total, and then an overall running
sum.
My year one projects id#s start with 1112, year two with 1213. I can't
figure
out how to get a label for year one and year two. It puts year one and
year
two on year one projects and year two projects. I have grouped on
project
year and project category (space or repair.) Thanks!!!

 

[golfinray]

I am not quite sure how to explain what I want but I'll try. You have a
report that prints projects for year one and year two. Year one in this case
is 2011-2012. Year two is 2012-2013. I have already idenified the projects
that are year one and year two in the query and sorted by that so that all
the year one print first then the year two. What I need is for a header or
subheader, or whatever you would call it to print "Year one" before the year
one projects and "Year two before the Year two projects. So if year two
starts on page 17, there is a label before the first project that says "Year
two." I have tried sorting and grouping and adding textboxes with the years
in them until I don't know what to do next. Thanks!!!
--
Milton Purdy
ACCESS
State of Arkansas

Milton,
You have hung out in these news group long enough that you should understand
that "That didn't do it for some reason" doesn’t cut it for some reason.

If you want some assistance, kick it up a notch and provide good
information, results, attempts, specs, ...

--
Duane Hookom
MS Access MVP

That didn't do it for some reason.
--
Milton Purdy
ACCESS
State of Arkansas

Can you not just use Left([ProjectID],4) AS [Project Year] and group
on
that?

--
Build a little, test a little.


:

I have a report built to show year one projects, then subcategory of
space
projects and repair projects. I also have budgets for each project,
each
category (repair and space), Grand Total, and then an overall running
sum.
My year one projects id#s start with 1112, year two with 1213. I can't
figure
out how to get a label for year one and year two. It puts year one and
year
two on year one projects and year two projects. I have grouped on
project
year and project category (space or repair.) Thanks!!!

 

[Steve]

Milton,

Please explain specifically how you did this using your actual field names
.......

<< I have already idenified the projects that are year one and year two in
the query >>

Steve
(e-mail address removed)

I am not quite sure how to explain what I want but I'll try. You have a
report that prints projects for year one and year two. Year one in this
case
is 2011-2012. Year two is 2012-2013. I have already idenified the projects
that are year one and year two in the query and sorted by that so that all
the year one print first then the year two. What I need is for a header or
subheader, or whatever you would call it to print "Year one" before the
year
one projects and "Year two before the Year two projects. So if year two
starts on page 17, there is a label before the first project that says
"Year
two." I have tried sorting and grouping and adding textboxes with the
years
in them until I don't know what to do next. Thanks!!!
--
Milton Purdy
ACCESS
State of Arkansas

Milton,
You have hung out in these news group long enough that you should
understand
that "That didn't do it for some reason" doesn't cut it for some reason.

If you want some assistance, kick it up a notch and provide good
information, results, attempts, specs, ...

--
Duane Hookom
MS Access MVP

That didn't do it for some reason.
--
Milton Purdy
ACCESS
State of Arkansas


:

Can you not just use Left([ProjectID],4) AS [Project Year] and
group
on
that?

--
Build a little, test a little.


:

I have a report built to show year one projects, then subcategory of
space
projects and repair projects. I also have budgets for each project,
each
category (repair and space), Grand Total, and then an overall
running
sum.
My year one projects id#s start with 1112, year two with 1213. I
can't
figure
out how to get a label for year one and year two. It puts year one
and
year
two on year one projects and year two projects. I have grouped on
project
year and project category (space or repair.) Thanks!!!

 

[Duane Hookom]

How do you define Year One and Year Two? Is the first year grouping in your
report always Year One and the second Year Two?

How/when did your values change from "1112" and "1213" to "2011-2012" and
"2012-2013"?

You should be able to create an expression that separates the years from the
project IDs. Have you been able to do this? What have you tried?


--
Duane Hookom
Microsoft Access MVP

I am not quite sure how to explain what I want but I'll try. You have a
report that prints projects for year one and year two. Year one in this case
is 2011-2012. Year two is 2012-2013. I have already idenified the projects
that are year one and year two in the query and sorted by that so that all
the year one print first then the year two. What I need is for a header or
subheader, or whatever you would call it to print "Year one" before the year
one projects and "Year two before the Year two projects. So if year two
starts on page 17, there is a label before the first project that says "Year
two." I have tried sorting and grouping and adding textboxes with the years
in them until I don't know what to do next. Thanks!!!
--
Milton Purdy
ACCESS
State of Arkansas

Milton,
You have hung out in these news group long enough that you should understand
that "That didn't do it for some reason" doesn’t cut it for some reason.

If you want some assistance, kick it up a notch and provide good
information, results, attempts, specs, ...

--
Duane Hookom
MS Access MVP

That didn't do it for some reason.
--
Milton Purdy
ACCESS
State of Arkansas


:

Can you not just use Left([ProjectID],4) AS [Project Year] and group
on
that?

--
Build a little, test a little.


:

I have a report built to show year one projects, then subcategory of
space
projects and repair projects. I also have budgets for each project,
each
category (repair and space), Grand Total, and then an overall running
sum.
My year one projects id#s start with 1112, year two with 1213. I can't
figure
out how to get a label for year one and year two. It puts year one and
year
two on year one projects and year two projects. I have grouped on
project
year and project category (space or repair.) Thanks!!!

 

[Steve]

Milton,

The solution you want lies here. That's why I asked the question!

Steve

Milton,

Please explain specifically how you did this using your actual field names
......

<< I have already idenified the projects that are year one and year two in
the query >>

Steve
(e-mail address removed)

I am not quite sure how to explain what I want but I'll try. You have a
report that prints projects for year one and year two. Year one in this
case
is 2011-2012. Year two is 2012-2013. I have already idenified the
projects
that are year one and year two in the query and sorted by that so that
all
the year one print first then the year two. What I need is for a header
or
subheader, or whatever you would call it to print "Year one" before the
year
one projects and "Year two before the Year two projects. So if year two
starts on page 17, there is a label before the first project that says
"Year
two." I have tried sorting and grouping and adding textboxes with the
years
in them until I don't know what to do next. Thanks!!!
--
Milton Purdy
ACCESS
State of Arkansas

Milton,
You have hung out in these news group long enough that you should
understand
that "That didn't do it for some reason" doesn't cut it for some reason.

If you want some assistance, kick it up a notch and provide good
information, results, attempts, specs, ...

--
Duane Hookom
MS Access MVP

That didn't do it for some reason.
--
Milton Purdy
ACCESS
State of Arkansas


:

Can you not just use Left([ProjectID],4) AS [Project Year] and
group
on
that?

--
Build a little, test a little.


:

I have a report built to show year one projects, then subcategory
of
space
projects and repair projects. I also have budgets for each project,
each
category (repair and space), Grand Total, and then an overall
running
sum.
My year one projects id#s start with 1112, year two with 1213. I
can't
figure
out how to get a label for year one and year two. It puts year one
and
year
two on year one projects and year two projects. I have grouped on
project
year and project category (space or repair.) Thanks!!!

 

[golfinray]

Year one and year two are defined in the query that drives the report.
Project numbers start with four numbers. 1112-4506-003 or 1213-1287-012, like
that. So in the query I stripped the first four numbers and use them to
define year one and year two. We can use 1112 as year one or I can convert
those to 2011-2012 whichever is easier. Then on the report, I have have a
header that says "Projects by year." Then I can sort in the query based on
those first four numbers to get them separated where the year one prints
first and the year two prints second. What I can't seem to do is get a
subheader that says Year one, then when the Year two starts, get a subheader
that says Year two. Thanks so much!!!
--
Milton Purdy
ACCESS
State of Arkansas

How do you define Year One and Year Two? Is the first year grouping in your
report always Year One and the second Year Two?

How/when did your values change from "1112" and "1213" to "2011-2012" and
"2012-2013"?

You should be able to create an expression that separates the years from the
project IDs. Have you been able to do this? What have you tried?


--
Duane Hookom
Microsoft Access MVP

I am not quite sure how to explain what I want but I'll try. You have a
report that prints projects for year one and year two. Year one in this case
is 2011-2012. Year two is 2012-2013. I have already idenified the projects
that are year one and year two in the query and sorted by that so that all
the year one print first then the year two. What I need is for a header or
subheader, or whatever you would call it to print "Year one" before the year
one projects and "Year two before the Year two projects. So if year two
starts on page 17, there is a label before the first project that says "Year
two." I have tried sorting and grouping and adding textboxes with the years
in them until I don't know what to do next. Thanks!!!
--
Milton Purdy
ACCESS
State of Arkansas

Milton,
You have hung out in these news group long enough that you should understand
that "That didn't do it for some reason" doesn’t cut it for some reason.

If you want some assistance, kick it up a notch and provide good
information, results, attempts, specs, ...

--
Duane Hookom
MS Access MVP

That didn't do it for some reason.
--
Milton Purdy
ACCESS
State of Arkansas


:

Can you not just use Left([ProjectID],4) AS [Project Year] and group
on
that?

--
Build a little, test a little.


:

I have a report built to show year one projects, then subcategory of
space
projects and repair projects. I also have budgets for each project,
each
category (repair and space), Grand Total, and then an overall running
sum.
My year one projects id#s start with 1112, year two with 1213. I can't
figure
out how to get a label for year one and year two. It puts year one and
year
two on year one projects and year two projects. I have grouped on
project
year and project category (space or repair.) Thanks!!!

 

[Duane Hookom]

If year one and year two are defined in the query then why not just group on
the defined column?

You can then add a couple text boxes to the group header section:
Name: txtCountYear
Control Source: =1
Running Sum: Over All
Visible: No
another:
Name: txtDisplayYear
Control Source: ="Year " & Choose(txtCountYear,"One", "Two","After")
Visible: Yes

--
Duane Hookom
Microsoft Access MVP

Year one and year two are defined in the query that drives the report.
Project numbers start with four numbers. 1112-4506-003 or 1213-1287-012, like
that. So in the query I stripped the first four numbers and use them to
define year one and year two. We can use 1112 as year one or I can convert
those to 2011-2012 whichever is easier. Then on the report, I have have a
header that says "Projects by year." Then I can sort in the query based on
those first four numbers to get them separated where the year one prints
first and the year two prints second. What I can't seem to do is get a
subheader that says Year one, then when the Year two starts, get a subheader
that says Year two. Thanks so much!!!
--
Milton Purdy
ACCESS
State of Arkansas

How do you define Year One and Year Two? Is the first year grouping in your
report always Year One and the second Year Two?

How/when did your values change from "1112" and "1213" to "2011-2012" and
"2012-2013"?

You should be able to create an expression that separates the years from the
project IDs. Have you been able to do this? What have you tried?


--
Duane Hookom
Microsoft Access MVP

I am not quite sure how to explain what I want but I'll try. You have a
report that prints projects for year one and year two. Year one in this case
is 2011-2012. Year two is 2012-2013. I have already idenified the projects
that are year one and year two in the query and sorted by that so that all
the year one print first then the year two. What I need is for a header or
subheader, or whatever you would call it to print "Year one" before the year
one projects and "Year two before the Year two projects. So if year two
starts on page 17, there is a label before the first project that says "Year
two." I have tried sorting and grouping and adding textboxes with the years
in them until I don't know what to do next. Thanks!!!
--
Milton Purdy
ACCESS
State of Arkansas


:

Milton,
You have hung out in these news group long enough that you should understand
that "That didn't do it for some reason" doesn’t cut it for some reason.

If you want some assistance, kick it up a notch and provide good
information, results, attempts, specs, ...

--
Duane Hookom
MS Access MVP

That didn't do it for some reason.
--
Milton Purdy
ACCESS
State of Arkansas


:

Can you not just use Left([ProjectID],4) AS [Project Year] and group
on
that?

--
Build a little, test a little.


:

I have a report built to show year one projects, then subcategory of
space
projects and repair projects. I also have budgets for each project,
each
category (repair and space), Grand Total, and then an overall running
sum.
My year one projects id#s start with 1112, year two with 1213. I can't
figure
out how to get a label for year one and year two. It puts year one and
year
two on year one projects and year two projects. I have grouped on
project
year and project category (space or repair.) Thanks!!!