Test

[raychunghk]

SELECT MSysIMEXSpecs.SpecName, MSysIMEXColumns.FieldName, MSysIMEXColumns.Attributes, IIf([datatype]=1,"Yes/No",IIf([datatype]=2,"Byte",IIf([datatype]=3,"Integer",IIf([datatype]=4,"Long Integer",IIf([datatype]=5,"Currency",IIf([datatype]=6,"Single",IIf([datatype]=7,"Double",IIf([datatype]=8,"Date/Time",IIf([datatype]=10,"Text",IIf([datatype]=12,"Memo",IIf([datatype]=13,"Hyperlink"))))))))))) AS Expr1, MSysIMEXColumns.IndexType, MSysIMEXColumns.Start, MSysIMEXColumns.Width, MSysIMEXColumns.SkipColumn
FROM MSysIMEXColumns INNER JOIN MSysIMEXSpecs ON MSysIMEXColumns.SpecID = MSysIMEXSpecs.SpecID
ORDER BY MSysIMEXSpecs.SpecName, MSysIMEXColumns.Start, MSysIMEXColumns.Width;