Calculation Queries

  • Thread starter Thread starter Dshatwell
  • Start date Start date
D

Dshatwell

I have been working this today and I am confused. Is there anyone
that can look at this query and understand why the calc does not work?
I am getting an aggregated funciton error when the calc is added to
the query.



SELECT

Loss_reserve_data.[LO Type],

Loss_reserve_data.Investor_ID,

Loss_reserve_data.XCategory_Code,

Loss_reserve_data.[XFirst Principal Bal],

Loss_reserve_data.[Annual Interest Rate],

Loss_reserve_data.[Floreclosure Stop Code],

SUM(Loss_reserve_data.[XFirst Principal Bal]*Loss_reserve_data.[annual
interest rate]) AS Yearly,

[Half] AS Expr2

INTO FHA_VH FROM Loss_reserve_data

WHERE (((Loss_reserve_data.Investor_ID)='005') AND
((Loss_reserve_data.XCategory_Code) In
('807','808','809','810','811','812','901','902')) AND
((Loss_reserve_data.[XFirst Principal Bal])<>'0.00')) OR

(((Loss_reserve_data.Investor_ID)='700') AND
((Loss_reserve_data.XCategory_Code)='900') AND
((Loss_reserve_data.[XFirst Principal Bal])<>'0.00')) OR

(((Loss_reserve_data.Investor_ID)='900') AND
((Loss_reserve_data.XCategory_Code) In ('001','002','003','004')) AND
((Loss_reserve_data.[XFirst Principal Bal])<>'0.00')) OR

(((Loss_reserve_data.Investor_ID)='902') AND
((Loss_reserve_data.XCategory_Code) In ('500','600')) AND
((Loss_reserve_data.[XFirst Principal Bal])<>'0.00')) OR

(((Loss_reserve_data.Investor_ID)='910') AND
((Loss_reserve_data.XCategory_Code)='701') AND
((Loss_reserve_data.[XFirst Principal Bal])<>'0.00')) OR

(((Loss_reserve_data.Investor_ID) Like 'N*') AND
((Loss_reserve_data.[XFirst Principal Bal])<>'0.00')) OR
(((Loss_reserve_data.Investor_ID)='F20') AND ((Loss_reserve_data.[XFirst
Principal Bal])<>'0.00')) OR (((Loss_reserve_data.Investor_ID)='F90')
AND ((Loss_reserve_data.[XFirst Principal Bal])<>'0.00')) OR

(((Loss_reserve_data.[LO Type]) In ('1','2')) AND
((Loss_reserve_data.Investor_ID) In ('910','200')) AND
((Loss_reserve_data.[XFirst Principal Bal])<>'0.00'));
 
Back
Top