Grouping

[Melinda]

I have a report tracking overtime hours, there are some employees who work at
a remote location and I need to group them together at the bottom of the
report, in their own little group. I have a field [Outpost] which is a yes
or no field. How would I sort or group a yes or not field together at the
bottom of the group.

Thanks
Melinda

 

[Duane Hookom]

Have you tried adding a primary Sorting and Grouping level on an expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.

 

[Melinda]

I moved the [Outpost] field to the first line in the sorting and grouping and
that moved the outpost to the top of the report and grouped them together
which would of course be alright. I was going to try what you said, but
forgive me I am new at all this, but where in the sorting and grouping box
would I type this. I tried switching the field to an expression so that I
can type in the sort order but was unsuccessful. thanks--melinda

Have you tried adding a primary Sorting and Grouping level on an expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.
--
Duane Hookom
MS Access MVP

I have a report tracking overtime hours, there are some employees who work
at
a remote location and I need to group them together at the bottom of the
report, in their own little group. I have a field [Outpost] which is a
yes
or no field. How would I sort or group a yes or not field together at the
bottom of the group.

Thanks
Melinda

 

[Duane Hookom]

You would type the expression in the Field/Expression column.

--
Duane Hookom
MS Access MVP

I moved the [Outpost] field to the first line in the sorting and grouping
and
that moved the outpost to the top of the report and grouped them together
which would of course be alright. I was going to try what you said, but
forgive me I am new at all this, but where in the sorting and grouping box
would I type this. I tried switching the field to an expression so that I
can type in the sort order but was unsuccessful. thanks--melinda

Have you tried adding a primary Sorting and Grouping level on an
expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.
--
Duane Hookom
MS Access MVP

I have a report tracking overtime hours, there are some employees who
work
at
a remote location and I need to group them together at the bottom of
the
report, in their own little group. I have a field [Outpost] which is
a
yes
or no field. How would I sort or group a yes or not field together at
the
bottom of the group.

Thanks
Melinda

 

[Melinda]

thanks so much, it worked and I learned somethin new. Thanks again

You would type the expression in the Field/Expression column.

--
Duane Hookom
MS Access MVP

I moved the [Outpost] field to the first line in the sorting and grouping
and
that moved the outpost to the top of the report and grouped them together
which would of course be alright. I was going to try what you said, but
forgive me I am new at all this, but where in the sorting and grouping box
would I type this. I tried switching the field to an expression so that I
can type in the sort order but was unsuccessful. thanks--melinda

Have you tried adding a primary Sorting and Grouping level on an
expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.
--
Duane Hookom
MS Access MVP

I have a report tracking overtime hours, there are some employees who
work
at
a remote location and I need to group them together at the bottom of
the
report, in their own little group. I have a field [Outpost] which is
a
yes
or no field. How would I sort or group a yes or not field together at
the
bottom of the group.

Thanks
Melinda

 

[Melinda]

Duane--could I ask one last question. The outpost people I was sorting to
the bottom of the report. I need to add a label to differentiate them as
Outpost Employees--when I add the label I added it to the =IIF([Outpost],2,1)
footer and it appears on the report at the beginning of those employees and
at the end of the those employees. How do I eliminate the label being at the
end? Thanks

thanks so much, it worked and I learned somethin new. Thanks again

You would type the expression in the Field/Expression column.

--
Duane Hookom
MS Access MVP

I moved the [Outpost] field to the first line in the sorting and grouping
and
that moved the outpost to the top of the report and grouped them together
which would of course be alright. I was going to try what you said, but
forgive me I am new at all this, but where in the sorting and grouping box
would I type this. I tried switching the field to an expression so that I
can type in the sort order but was unsuccessful. thanks--melinda

:

Have you tried adding a primary Sorting and Grouping level on an
expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.
--
Duane Hookom
MS Access MVP

I have a report tracking overtime hours, there are some employees who
work
at
a remote location and I need to group them together at the bottom of
the
report, in their own little group. I have a field [Outpost] which is
a
yes
or no field. How would I sort or group a yes or not field together at
the
bottom of the group.

Thanks
Melinda

 

[Duane Hookom]

I don't understand. You stated you added a label in the footer but don't
want it at the end?


--
Duane Hookom
MS Access MVP

Duane--could I ask one last question. The outpost people I was sorting
to
the bottom of the report. I need to add a label to differentiate them as
Outpost Employees--when I add the label I added it to the
=IIF([Outpost],2,1)
footer and it appears on the report at the beginning of those employees
and
at the end of the those employees. How do I eliminate the label being at
the
end? Thanks

thanks so much, it worked and I learned somethin new. Thanks again

You would type the expression in the Field/Expression column.

--
Duane Hookom
MS Access MVP

I moved the [Outpost] field to the first line in the sorting and
grouping
and
that moved the outpost to the top of the report and grouped them
together
which would of course be alright. I was going to try what you said,
but
forgive me I am new at all this, but where in the sorting and
grouping box
would I type this. I tried switching the field to an expression so
that I
can type in the sort order but was unsuccessful. thanks--melinda

:

Have you tried adding a primary Sorting and Grouping level on an
expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.
--
Duane Hookom
MS Access MVP

I have a report tracking overtime hours, there are some employees
who
work
at
a remote location and I need to group them together at the bottom
of
the
report, in their own little group. I have a field [Outpost]
which is
a
yes
or no field. How would I sort or group a yes or not field
together at
the
bottom of the group.

Thanks
Melinda

 

[Melinda]

After I sorted the report showing who worked at the outpost and who didn't I
hid that field so I was adding a label in order to show which employees
worked at the outpost. I have those employees listed at the bottom of the
report. I added a label but it shows the label above those employees and
another label below those employees. Does that describe it a bit better?

I don't understand. You stated you added a label in the footer but don't
want it at the end?


--
Duane Hookom
MS Access MVP

Duane--could I ask one last question. The outpost people I was sorting
to
the bottom of the report. I need to add a label to differentiate them as
Outpost Employees--when I add the label I added it to the
=IIF([Outpost],2,1)
footer and it appears on the report at the beginning of those employees
and
at the end of the those employees. How do I eliminate the label being at
the
end? Thanks

thanks so much, it worked and I learned somethin new. Thanks again

:

You would type the expression in the Field/Expression column.

--
Duane Hookom
MS Access MVP

I moved the [Outpost] field to the first line in the sorting and
grouping
and
that moved the outpost to the top of the report and grouped them
together
which would of course be alright. I was going to try what you said,
but
forgive me I am new at all this, but where in the sorting and
grouping box
would I type this. I tried switching the field to an expression so
that I
can type in the sort order but was unsuccessful. thanks--melinda

:

Have you tried adding a primary Sorting and Grouping level on an
expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.
--
Duane Hookom
MS Access MVP

I have a report tracking overtime hours, there are some employees
who
work
at
a remote location and I need to group them together at the bottom
of
the
report, in their own little group. I have a field [Outpost]
which is
a
yes
or no field. How would I sort or group a yes or not field
together at
the
bottom of the group.

Thanks
Melinda

 

[Duane Hookom]

Both the OutPost and non-OutPost groups will each have the same group
sections unless you cancel or hide a section.
You might get by with using an expression in the Control Source of a text
box like:
=IIF([Outpost],"Outpost",Null)

--
Duane Hookom
MS Access MVP

After I sorted the report showing who worked at the outpost and who didn't
I
hid that field so I was adding a label in order to show which employees
worked at the outpost. I have those employees listed at the bottom of
the
report. I added a label but it shows the label above those employees and
another label below those employees. Does that describe it a bit better?

I don't understand. You stated you added a label in the footer but don't
want it at the end?


--
Duane Hookom
MS Access MVP

Duane--could I ask one last question. The outpost people I was
sorting
to
the bottom of the report. I need to add a label to differentiate them
as
Outpost Employees--when I add the label I added it to the
=IIF([Outpost],2,1)
footer and it appears on the report at the beginning of those employees
and
at the end of the those employees. How do I eliminate the label being
at
the
end? Thanks

:

thanks so much, it worked and I learned somethin new. Thanks again

:

You would type the expression in the Field/Expression column.

--
Duane Hookom
MS Access MVP

I moved the [Outpost] field to the first line in the sorting and
grouping
and
that moved the outpost to the top of the report and grouped them
together
which would of course be alright. I was going to try what you
said,
but
forgive me I am new at all this, but where in the sorting and
grouping box
would I type this. I tried switching the field to an expression
so
that I
can type in the sort order but was unsuccessful. thanks--melinda

:

Have you tried adding a primary Sorting and Grouping level on an
expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.
--
Duane Hookom
MS Access MVP

I have a report tracking overtime hours, there are some
employees
who
work
at
a remote location and I need to group them together at the
bottom
of
the
report, in their own little group. I have a field [Outpost]
which is
a
yes
or no field. How would I sort or group a yes or not field
together at
the
bottom of the group.

Thanks
Melinda

 

[Melinda]

That will do me, done with the report, thanks so much and have a good weekend.

Both the OutPost and non-OutPost groups will each have the same group
sections unless you cancel or hide a section.
You might get by with using an expression in the Control Source of a text
box like:
=IIF([Outpost],"Outpost",Null)

--
Duane Hookom
MS Access MVP

After I sorted the report showing who worked at the outpost and who didn't
I
hid that field so I was adding a label in order to show which employees
worked at the outpost. I have those employees listed at the bottom of
the
report. I added a label but it shows the label above those employees and
another label below those employees. Does that describe it a bit better?

I don't understand. You stated you added a label in the footer but don't
want it at the end?


--
Duane Hookom
MS Access MVP

Duane--could I ask one last question. The outpost people I was
sorting
to
the bottom of the report. I need to add a label to differentiate them
as
Outpost Employees--when I add the label I added it to the
=IIF([Outpost],2,1)
footer and it appears on the report at the beginning of those employees
and
at the end of the those employees. How do I eliminate the label being
at
the
end? Thanks

:

thanks so much, it worked and I learned somethin new. Thanks again

:

You would type the expression in the Field/Expression column.

--
Duane Hookom
MS Access MVP

I moved the [Outpost] field to the first line in the sorting and
grouping
and
that moved the outpost to the top of the report and grouped them
together
which would of course be alright. I was going to try what you
said,
but
forgive me I am new at all this, but where in the sorting and
grouping box
would I type this. I tried switching the field to an expression
so
that I
can type in the sort order but was unsuccessful. thanks--melinda

:

Have you tried adding a primary Sorting and Grouping level on an
expression
like:

=IIf([OutPost], 2, 1)

This would print all OutPost records last.
--
Duane Hookom
MS Access MVP

I have a report tracking overtime hours, there are some
employees
who
work
at
a remote location and I need to group them together at the
bottom
of
the
report, in their own little group. I have a field [Outpost]
which is
a
yes
or no field. How would I sort or group a yes or not field
together at
the
bottom of the group.

Thanks
Melinda