Search results

  1. B

    Using Top predicate in complex pivot query

    Hi all, With help from Thedbguy, I have created quite a complex query feeding into a report. I now need to change the query to include a subset of the records for sorting and grouping. It looks to me like I need the Top predicate (asc) but is this so and where should it go within the query...
  2. B

    Sort or Group by value

    Folks, I have a report that's done sterling service for some years (Access 2003). The detail is currently sorted by info in the report record source, a number descending (raced) and then another number ascending (pos). There's a new requirement to add another sort (or group?) before these two...
Top Bottom