Search results

  1. A

    Running total for only last two groups

    Sorry for not being clear. I quite didn't understand what you are asking but let me explain the structure of my database or the source for my report. The report's recrod source is set to a query that gets the data from two tables. In the report I have created a group on one of the fields...
  2. A

    Running total for only last two groups

    Hello, I need help adding the last two groups together. Group 1 XX YY $5.00 Group 2 AA BB $4.00 BB CC $3.00 Group 3 CC DD $10.00 AA BB $5.00 EE FF $5.00 Group 4 TT BB $2.00 SK FH $1.00 Total: (Here I would like to add Group 3 and 4 only. So the answer would be $23) Thanks for your time...
  3. A

    Custom Labels in Group Header

    Switch function does the trick, so does sub reports...Thank You!
  4. A

    Custom Labels in Group Header

    I would like to add label "Net Gross Profit" Just for the "Cost of Goods Sold" Category. Right now i got it to work by adding a record to my table. Here is an image. Sorry, I couldn't add an image in here since I don't have 10 or more posts...
  5. A

    Custom Labels in Group Header

    Let me try to be more clear: This is what I would like to accomplish. Category1 Record 1 Record 2 Record 3 Label1: "This is Category1" Category2 Record 1 Label2: "This is Category2" Category3 Record 1 Record 2 Label3: "This is Category3" I would like unique label for each...
  6. A

    Custom Labels in Group Header

    I already have a report designed. It is a simple report that groups the records by category. So for instance, Category1, Category 2, Category 3. Now each Category has different number of records. What I want to do is add a label at the end of each Category, but this label will be different...
Back
Top Bottom