Upsizing failed on IIF

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

I just did an upsizing to SQL Server 2000. In the MDB file I had this query:
APSStatus:
IIf(IsNull(qryAPSIncompleteCount.CountOfAPSStatus),0,qryAPSIncompleteCount.CountOfAPSStatus)

This did not survive the upsizing. This was in a relatively small databasee
serving as a pilot project before the real deal. For example, on the server
IsNull has two arguments.

The real deal will involve many IIFs. If the upsizing can't handle an IIF,
what should I do to prepare to restore or rebuild all of those expressions?

Is there a road map somehwere on upsizing? Book? Website?
 
You should check SQL Books On Line. You can probably use
Coalesce(CountOfAPSStatus,0)
 
Thanks for the reply. Anything I can do/read on shaping the existing
databases for a smooth trransition during Upsizing?
 
You could probably write your own Coalesce function in Access. After
upsizing, delete the function since it already exists in SQL Server.
 
I got it to work. I had to remember to that I needed a left join to get all
the insureds, not just those who had a non-null value.
 
Back
Top