[AccessD] Time and Billing app

[Arthur Fuller]

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