Re: group without sort

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


.

Relevant Pages

  • Re: Strange running sum problem
    ... If so, run the query directly and see if the column displays left-aligned or right-aligned If left, you need to alter the expression so that JET knows it's a number. ... set the Format property of the Running Sum text box on the report to something numeric ... The sort is by month and I ...
    (microsoft.public.access.reports)
  • Re: group without sort
    ... you can create a totals query grouped on ... source for a subreport to place in the report footer of your main report. ... I have added a group footer on name with sort ... > day, an employee will work on a job in the parc budget) To do that, I ...
    (microsoft.public.access.reports)
  • Re: group without sort
    ... >I have a main report with the date and the weather conditions (Date is the ... TruckNumber, Rate, Budget, NumberHours. ... >the total sums in budget without using running sum? ... RunningSum will have an affect on the subreport's sorting. ...
    (microsoft.public.access.reports)
  • group without sort
    ... I have a main report with the date and the weather conditions (Date is the ... I want to calculate the cost of each budget at each day. ... the Budget group footer. ... the total sums in budget without using running sum? ...
    (microsoft.public.access.reports)
  • Re: paranoid?
    ... budget in comparison. ... Same sort of report which said the Rafa's got the measure of Chelsea just before they arse raped them 4-1 at their own ground ... ...
    (uk.sport.football.clubs.liverpool)