Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Access to Sql

Author  Topic 

h2sut
Starting Member

40 Posts

Posted - 2008-06-24 : 11:38:50
Does anyone know how to convert this access to Sql. Are there any programs that will do it for you

IIf([Ceridian]![UnionIndicator]="U" And [YearsService]>=3,[HealthBenefits]![medplan.Bi-WeeklyURBio-Rad]*26,[HealthBenefits]![medplan.Bi-WeeklyBio-Rad]*26) AS MedicalCostER, IIf([Ceridian]![UnionIndicator]="U" And [YearsService]>=3,[medplan]![Bi-WeeklyUREE]*26,[medplan]![Bi-WeeklyEE]*26) AS MEdicalCostEE,

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-06-24 : 13:38:09
I have given you the hint
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105449

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -