Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JoshYeadon

  1. JoshYeadon

    combine reports

    If you can manage to get all the required data into just the one single report, you can specify a group range in the crosstab. If you have the 'customer.name' in the Row section & the '.date' field in the Column section, this will do what im thinking you are wanting it to do... When the date...
  2. JoshYeadon

    Counting the appearances of a field...

    Thanks guys, I used the "distinctcouont({transaction_ID},Client.Ref})" formula and this worked absolutely fine. I was missing the distinct count and the ID field as some dates were the same, meaning when i used the .when, it counted them incorrectly. Thanks
  3. JoshYeadon

    Counting the appearances of a field...

    Right, I have 2 tables linked together in the same report. Table one contains all the payments made to the company as Fees. Table two contains all the disbursements made to the creditors. When i try to count to Fee Payments & the Disbursements seperately...i get a grand total of the 2...

Part and Inventory Search

Back
Top