Search results

  1. M

    Calculating Column Totals

    I have a table with revenue by contract imported from crystal reports. This data is then thrown in a query to match the contract with the corresponding account rep. The query is set to prompt the end user to enter the account rep name so that only revenue (and related data) is shown for that...
  2. M

    Multiple Calculations in a Query

    I need help with access2000!!!! I have a table with cost and revenue by contract. 1 contract can have multiple revenue sources. I created a query to sum total revenue by contract. That works fine. I also want to calculate gross profit (gp) dollars and gp% based on my sum total revenue field...
Back
Top Bottom