Re: group without sort

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


--
Rick B



"LouisPat" <LouisPat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ECF81EE8-54B6-4BB1-B897-A4644461A783@xxxxxxxxxxxxxxxx
> 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


.

Quantcast