calculations in queries

[Guest]

Hi,

I have the following query: SELECT qryCapitalExpExclNonProject.ProjectName,
Sum(qryCapitalExpExclNonProject.[Deprn Amount]) AS [SumOfDeprn Amount],
Sum(qryCapitalExpExclNonProject.[Ytd Deprn]) AS [SumOfYtd Deprn],
Sum(qryCapitalExpExclNonProject.Cost) AS SumOfCost,
Sum(qryCapitalExpExclNonProject.Nbv) AS SumOfNbv, [Enter the monthly COF
rate, as a decimal] AS MonthlyCOFRate, [MonthlyCOFRate]*[SumOfNbv]/12 AS COF
FROM qryCapitalExpExclNonProject
GROUP BY qryCapitalExpExclNonProject.ProjectName;

The calculation, [MonthlyCOFRate]*[SumOfNbv]/12 , needs to be changed to the
following: NBV*Rate*([days in the month]/360). How would you recommend that
be done in SQL syntax?

Thanks,

Dave

 

[Guest]

The formula included will return the number of days in the current month.
NBV*Rate*(Day(DateAdd("d",-1,DateSerial(Year(Date),Month(Date)+1,1)))/360)