[AccessD] Time and Billing app

[Rocky Smolin]

I've had the same problem with sort order if the Record Source is a table
or query.  I did solve it just recently by moving the field I wanted for a
primary sort to the first column in the QBE grid and set the sort on that
field to ascending.  That worked.


HTH

r
On Thu, Mar 23, 2023 at 4:23 PM Ryan W <wrwehler at gmail.com> wrote:

> Remove the filter criteria and check your sorting/groping in the report/sub
> report?  Setting it at the RecordSource doesn't seem to do it for reports.
>
>
>
> On Thu, Mar 23, 2023 at 5:59 PM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > Stuart,'
> > I did go there and set them to OrderByOn = Yes and OrderBy = [Date
> Worked]
> > DESC. That didn't work.
> >
> > On Thu, Mar 23, 2023 at 6:03 PM Stuart McLachlan <stuart at lexacorp.com.pg
> >
> > wrote:
> >
> > > Check the "Report Properties" in design mode and make sure you haven't
> > set
> > > OrderByOn = Yes and OrderBy = [Date Worked]
> > >
> > > Bloody templates built by interns using tbale and field names with
> > spaces,
> > > no consistent
> > > naming conventions and macros everywhere!
> > >
> > > That's where people learn their bad habits - and then they want us to
> go
> > > in and fix it when it
> > > turns to cr*p.
> > >
> > >
> > >
> > >
> > > On 23 Mar 2023 at 17:43, Arthur Fuller wrote:
> > >
> > > > My little company is so little that the Access template Time and
> > > > Billing app is quite sufficient for my needs. Besides, as the saying
> > > > goes, "The shoemaker's kids go barefoot." I'm too busy finishing the
> > > > next edition of Getting It Done..." to roll my own app for such a
> > > > simple task.
> > > >
> > > > I've made a few changes such as the ability to deal with both US and
> > > > CDN currency, and modified the invoice to bear my company's name and
> > > > address, etc.
> > > >
> > > > The app prints invoices, among other things. The invoice is a report
> > > > containing three subreports, one of which is Billing Hours Subreport.
> > > > The data source for this subreport is a query called Billing Hours
> > > > All.
> > > >
> > > > Therein lies the problem. It prints the rows by Date Worked
> ascending.
> > > > I want them to appear in Descending order, so the most recent hours
> > > > appear at the top.
> > > >
> > > > I have tried everything I can think of to change this behaviour. I've
> > > > opened the query in Query Builder and specified the Order By there.
> > > > I've specified Order By Date Worked DESC on the report itself. In
> > > > Query Builder I moved the Hours worked column to the leftmost
> > > > position. When I run the query in Builder, it behaves the way I want.
> > > > But when I run the Invoice, the rows appear in Ascending order.
> > > >
> > > > I don't know what else to try. I have no idea why my specific
> > > > instructions are being ignored.
> > > >
> > > > Suggestions?
> > > >
> > > > --
> > > > Arthur
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>