I am attempting to upsize to an Access Project(SQL Server 7.0) and have

encountered several issues.  The upsizing wizard skipped several queries.

They all use the IIF function to create a new field in the query.  It

appears IIF is not supported in an Access Project.  Any suggestions on how

to recode using Access Project View.



Also I am having an issue with the upsized Project View design screen.  

The Diagram pane does not show individual columns for the tables in the 

view.  It displays Select All Columns but no detail.  I have reviewed the 

Northwind project and the detail columns show.  Any suggestions?



Thank You,



Jonathan M. Tarr