Search results

  1. S

    Calculation on specific records in query

    This is my code but it is not returning proper results. CalcServicePeriod query calculates each customer's SPStartDate and SPEndDate NSLS table has DailyCons and DailyCost by Date NSLS.Date is related to CalcServicePeriod.SPStartDate I need the query to look at each customers SPStartDate and...
  2. S

    Query Calculation with specific records from unrelated tables

    I am trying to calculate a weighted average commodity price for each of my customers who have various billing periods. I have my customer data in 'CustomerData' table and daily commodity pricing in 'TotalConsumption' table. I am trying to calculate the average commodity price...
Back
Top Bottom