[AccessD] Time and Billing app

[Stuart McLachlan]

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
>