group without sort

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LouisPat - 28 Jul 2005 19:58 GMT

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

Reply to this Message

Rick B - 28 Jul 2005 21:04 GMT

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

Signature

Rick B

> HI!
>
[quoted text clipped - 20 lines]
>
> Louis Pat

Reply to this Message

Marshall Barton - 28 Jul 2005 22:15 GMT

>Is it possible to group without sorting in a report in access 2000?
>It is a database for the publicworks of a city
[quoted text clipped - 14 lines]
>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)

Signature

Marsh
MVP [MS Access]

Reply to this Message

LouisPat - 29 Jul 2005 13:14 GMT

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
[quoted text clipped - 24 lines]
> properties are not set correctly (I think you want to only
> use the date field)

Reply to this Message

Duane Hookom - 29 Jul 2005 13:40 GMT

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.

Signature

Duane Hookom
MS Access MVP

> Good morning...
>
[quoted text clipped - 53 lines]
>> properties are not set correctly (I think you want to only
>> use the date field)

Reply to this Message