Search results

  1. E

    Query with

    Thank you. Your query does not include field for the variance of the previous month. The calculations for the Cummulative variance is not correct if I select a different date please.
  2. E

    Query with

    Please I updated the query (see attached). Vehicle Recreational report. I run it with dates between 1st-30th June 2020. The image has the intended results. thanks for your help.
  3. E

    Query with

    Yes I know. I was just trying to let you understand the scenario. In the image, I put alphabets underneath the column names for you to see how the calculation is done. Hope you understand.
  4. E

    Query with

    Hello again, I attached the sample DB and an image of the intended report. Kindly see it.
  5. E

    Query with

    Hi, Thank you for your quick response: There is a date column for the table. The parameters will be passed to the query through a form (DateFrom for the beginning date and DateTo for the end date).
  6. E

    Query with

    Hello, I am trying to create a query from a table that will calculate fields whereby different date parameters will be used for different fields/columns. For instance 1st column is to calculate a field with a date range. the 2nd column will calculate a field with respect to a previous date and...
Back
Top Bottom