group without sort

[LouisPat]

HI!

Is it possible to group without sorting in a report in access 2000?
It is a database for the publicworks of a city
I have a main report with the date and the weather conditions (Date is the
primary key),
In that report, I have a subreport with a NAME group header that sort my
employees from a to z. In the detail section, I have information about a job
they did a certain day: TruckNumber, Rate, Budget, NumberHours. I also
created a text box that calculates the cost of that job: CostJob =
[NumberHours] *[Rate]

I want to calculate the cost of each budget at each day. I made that
possible by making a running sum on group on the textbox CostJobBudget, in
the Budget group footer. This footer is not visible, as I will use this text
box in the main report.
But now my list of employees is sorted by budget and then by alphabetical
order, and i do not want that.
Is there a way to not sort and group, or is there another way of calculating
the total sums in budget without using running sum?

Thank you for helping

Louis Pat

 

[Rick B]

You say you want to "not sort". Well, they have to be in SOME order. What
order do you want them in?

 

[Marshall Barton]

Is it possible to group without sorting in a report in access 2000?
It is a database for the publicworks of a city
I have a main report with the date and the weather conditions (Date is the
primary key),
In that report, I have a subreport with a NAME group header that sort my
employees from a to z. In the detail section, I have information about a job
they did a certain day: TruckNumber, Rate, Budget, NumberHours. I also
created a text box that calculates the cost of that job: CostJob =
[NumberHours] *[Rate]

I want to calculate the cost of each budget at each day. I made that
possible by making a running sum on group on the textbox CostJobBudget, in
the Budget group footer. This footer is not visible, as I will use this text
box in the main report.
But now my list of employees is sorted by budget and then by alphabetical
order, and i do not want that.
Is there a way to not sort and group, or is there another way of calculating
the total sums in budget without using running sum?

Nothing in your description, and certainly nothing about
RunningSum will have an affect on the subreport's sorting.

Double check the subreport's Sorting and Grouping list to
make sure the budget field is not specified. THe only other
reason I can think of that may cause something like you
problem is if the subreport control's Link Master/Child
properties are not set correctly (I think you want to only
use the date field)

 

[LouisPat]

Good morning...

When I print my report , I want it to be sorted by the employee name in
alphabetical order only. I have added a group footer on name with sort
ascending and it worked perfectly.
But then I figured that I needed to calculate budget costs. (On a certain
day, an employee will work on a job in the parc budget) To do that, I created
a budget group footer and put a text box with a running sum on the cost ->
rate * hours

For my calculations, i want my report to be sorted by budget ( But the
budget footer is invisible). But when I print, i want it to be sorted from a
to z.
If i can't do that, do you have another idea on how I could calculate my
budget costs?

Thanks guys! I really appreciate it

Louis Pat

Is it possible to group without sorting in a report in access 2000?
It is a database for the publicworks of a city
I have a main report with the date and the weather conditions (Date is the
primary key),
In that report, I have a subreport with a NAME group header that sort my
employees from a to z. In the detail section, I have information about a job
they did a certain day: TruckNumber, Rate, Budget, NumberHours. I also
created a text box that calculates the cost of that job: CostJob =
[NumberHours] *[Rate]

I want to calculate the cost of each budget at each day. I made that
possible by making a running sum on group on the textbox CostJobBudget, in
the Budget group footer. This footer is not visible, as I will use this text
box in the main report.
But now my list of employees is sorted by budget and then by alphabetical
order, and i do not want that.
Is there a way to not sort and group, or is there another way of calculating
the total sums in budget without using running sum?

Nothing in your description, and certainly nothing about
RunningSum will have an affect on the subreport's sorting.

Double check the subreport's Sorting and Grouping list to
make sure the budget field is not specified. THe only other
reason I can think of that may cause something like you
problem is if the subreport control's Link Master/Child
properties are not set correctly (I think you want to only
use the date field)

 

[Duane Hookom]

If you want to sort and group by FieldA but want some totals at the end of
the report grouped by FieldB, you can create a totals query grouped on
FieldB with all the sums you want. Use this totals query as the record
source for a subreport to place in the report footer of your main report.

--
Duane Hookom
MS Access MVP

Good morning...

When I print my report , I want it to be sorted by the employee name in
alphabetical order only. I have added a group footer on name with sort
ascending and it worked perfectly.
But then I figured that I needed to calculate budget costs. (On a certain
day, an employee will work on a job in the parc budget) To do that, I
created
a budget group footer and put a text box with a running sum on the cost ->
rate * hours

For my calculations, i want my report to be sorted by budget ( But the
budget footer is invisible). But when I print, i want it to be sorted from
a
to z.
If i can't do that, do you have another idea on how I could calculate my
budget costs?

Thanks guys! I really appreciate it

Louis Pat

Is it possible to group without sorting in a report in access 2000?
It is a database for the publicworks of a city
I have a main report with the date and the weather conditions (Date is
the
primary key),
In that report, I have a subreport with a NAME group header that sort
my
employees from a to z. In the detail section, I have information about a
job
they did a certain day: TruckNumber, Rate, Budget, NumberHours. I also
created a text box that calculates the cost of that job: CostJob =
[NumberHours] *[Rate]

I want to calculate the cost of each budget at each day. I made that
possible by making a running sum on group on the textbox CostJobBudget,
in
the Budget group footer. This footer is not visible, as I will use this
text
box in the main report.
But now my list of employees is sorted by budget and then by
alphabetical
order, and i do not want that.
Is there a way to not sort and group, or is there another way of
calculating
the total sums in budget without using running sum?

Nothing in your description, and certainly nothing about
RunningSum will have an affect on the subreport's sorting.

Double check the subreport's Sorting and Grouping list to
make sure the budget field is not specified. THe only other
reason I can think of that may cause something like you
problem is if the subreport control's Link Master/Child
properties are not set correctly (I think you want to only
use the date field)