Recent content by General Ledger

Sorry but I am getting an error: Private Sub Customer_Footer_Format (Cancel As Integer, FormatCount As Integer) Me.Customer_Footer.Visible=(Count(*)>1) End Sub Returns Compile error: Syntax error I tried adding the field name I want to count Private Sub Customer_Footer_Format (Cancel As...

Dear All, I am a hack using Access 2007 that is looking for help on controlling the Visible property of a report section. I have a report with sorts, and group headers and footers. Footers contain subtotals for the group. I want to show or hide the footer based on the count of records in...

A mircle has occured. I did it! I created a new field in my query Salesperson Sort: IIF([SalesPerson]="Stock", 2, 1) In my report I added as the new first sort (without headers or footers) Salesperson Sort in ascending order. The next sort levels were the same as before (Salesperson...

Guys, Thanks so much for the great responses. It seems both answers have to do with creating addition fields to sort by but which are not displayed on the report. I really like AliasName: IIF([SalesPerson]="Stock", 2, 1) and I think something I can handle. I never worked with subreports so...

Dear All, First time using this forum. I am looking for information about how to customize sorting in Access 2007 reports. Issue #1: I have a report of open sales orders. I am sorting in ascending order and grouping by Salesperson (such as Al, Mary, Vinnie). I have one Salesperson called...