Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    81

    Unanswered: Totals in report (Help please)

    Hi guys,

    I need your help please. See attached database.

    What I will like to do is get totals in my report when I press either the print by date range or by month.

    1. Total number of jobs billed (This will be all jobs where the checkbox is selected)
    2. Total number of jobs cleared (This will be all the jobs with a cleared date entered)
    3. Total number of jobs not cleared (This will be all the jobs without a cleared date entered)

    I do not know how to get these totals in a report so could you please modify my report in the editor?

    Thanks a lot!
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2

    Take a look

    I attached a file with the calculations done.

    Just curious, I don't understand why you need to calculate jobs cleared.
    job billed is the same as job cleared right?

    anyway, both calculations are in the file.

    Regards
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2012
    Posts
    81
    Firstly thanks a lot.

    1. The date range report works fine
    2. The monthly report isnt working as when i try april by typing in 04 only zeros show in the report. Can this be fixed?
    3. Jobs billed isn't the same as sometimes when a shipment is cleared it may be billed several weeks after hence the reason for the separation.

  4. #4
    Join Date
    Jan 2012
    Posts
    81
    Solved....see attached
    Attached Files Attached Files
    Last edited by Trent; 05-08-13 at 11:52.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •