The following Microsoft Access queries are not supported in Iron Speed Designer:
Update, delete, and append queries
Union queries
Queries with parameters
Pivot and cross-tab queries
Queries using the builtin NZ function
Microsoft Access 2000 Versions
Microsoft Access Database Field Support
Query Support in Microsoft Access
Linked Databases in Microsoft Access
Relative and Absolute Path Names for Microsoft Access Databases
Accessing Microsoft SQL Server Tables through Microsoft Access Queries