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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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