[AccessD] Time and Billing app

[Arthur Fuller]

Ryan, I will try that.
Rocky, I did try that and it didn't work.
For now, it doesn't really matter because the report is only one page.
Stuart, you're probably right about an intern being the author. For one
thing, although it's called an invoice, it is in fact a statement. Anyone
with a minimum of accounting knowledge would know the difference. Maybe
I'll rename the existing pieces Statement, etc, and roll my own proper
Invoice. That's probably easier and quicker than chasing this down.

On Thu, Mar 23, 2023 at 7:30 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur