Make a query to return a table's properties...

[THEGREEK]

Is it possible to write a query via qbe grid or sql to bring back all of a tables attributes (ie. in the first column show only fields with a data type of text, in the second column only show field's with a data type of date/time and in the third column only show data types of Long integer for that table)

Is this is even possible?

Thanks in advance,
THEGREEK

 

[freewilly]

To my knowlege this is beyond what SQL was designed to do. It is easy in VBA. Post here if you want more details or if you want help.