Search results

  1. M

    Calculating Two Query Sums even if No data present

    Yes I see where I was getting the syntax wrong! Thank you so much! Michael
  2. M

    Calculating Two Query Sums even if No data present

    Oh my goodness YES! Thank you!! Michael
  3. M

    Calculating Two Query Sums even if No data present

    Uh oh. I have to admit this is all beyond my skills / knowledge at this point. Not sure how to correct this without screwing existing records up. :( Oh well. Thank you for any help you gave. Sigh. Michael
  4. M

    Calculating Two Query Sums even if No data present

    Hi all, I could not get the Nz format to work. I have attached the Database in Zip file here. Basically on report WorkOrderPrint I want the Grand Total to populate even if there is not a extra cost value. It is based of the form Work Order which has Child line items x2 (staffing and extra...
  5. M

    Calculating Two Query Sums even if No data present

    Oh, no I have not. Do you have a tip on how that is used in this scenario.
  6. M

    Calculating Two Query Sums even if No data present

    Hi there everyone, I have a report that generates from a "Work Order" and on the Work Order is two types of line items: one for Staffing Charges and one for Extra Costs. On the report WorkOrderPrint I have made sum fields for each line item section that work great, the problem I have is if there...
Back
Top Bottom