Recent content by sgjjw

Thanks for the help, I got it! You got me pointed in the right direction. Here is the code for future reference. I had to break the calculation down into 3 steps (TotalCost, TotalCons, then TotalCost/TotalCons) SELECT CalcServicePeriod.ID, CalcServicePeriod.SPStartDate...

What is the best way to post that?

Thanks for the suggestion. I tried it but got an error message: you tried to execute a query that does not include the specific expression '[Date] Between [SPStartDate] And [SPEndDate]' as part of an aggregate function. I tried a few things to fix it but had no luck...I have not done a...

Thanks Louie. I tried that code but it is giving me a syntax error (missing operator) in the DSum expression. I can't figure out what has been missed.

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...

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...