[JWasibpi]

I use a windows 2000 server with an SQL db. The following query gives me two "invalid columns", one named <b>PA</b> and the other named <b>BillAmt</b>

Any Ideas?

Select distinct Product.PremiumAdjustment as PA,
count(Product.ProductID) as ProdCount,
Sum(Product.BenefitAmount) as TotBenSum,
Sum(Product.ExpectedAmount) as BillAmt,

([BillAmt] + [PA]) as Premium

From Product

inner join PlanCode on PlanCode.PlanCodeID = Product.PlanCodeID
inner join PlanType on PlanType.PlanTypeID = PlanCode.PlanTypeID
Inner Join Payer on Product.PayerID = Payer.PayerID
Inner Join Employer on Employer.EmployerID = Payer.EmployerID
Inner Join BillMode on BillMode.BillModeID = Product.BillModeID
Inner Join BillingCycle on Product.BillingCycleID = BillingCycle.BillingCycleID

WHERE Product.EntryDate BETWEEN '5/1/2002' AND '5/5/2002'