Search results

  1. T

    Report problem

    I created a report with a border and a watermark logo in the center of the page. The fields on the report is too much for one page. Is there a way to have the border and logo shown on the other pages? i.e. the border and logo is only shown on Page 1 Also is there a way to format the fields...
  2. T

    Updating a field based on a certain criteria

    Is there a way in a query (using SQL) to go to the first record to update a field based on a criteria ? For example if my amount field shows two amounts for $300.00 I want to go to the first record that has $300.00 to update a field in that record. Is that possible?
  3. T

    Matching debits and credits

    How do I adjust the SQL query below so that if the client has 2 or more debits for the same amount say in the example below $1,272.00 and the client has 1 credit on their account for ($1,272.00), I would like the credit to be applied to any one of the debits once the amount is the same. The...
Back
Top Bottom