paul.hartland at fsmail.net
paul.hartland at fsmail.net
Wed May 19 10:07:03 CDT 2004
not sure if you can do it in a selected statement, if you can I would be very interets in seeing it. I ended up creating a table with the three fields in and writing a function using TableDef properties to update the table Message date : May 19 2004, 04:03 PM >From : "Arthur Fuller" To : "AccessD" Copy to : Subject : [AccessD] Select statements to get column definitions? Is there a way to write a SELECT statement so that its result looks similar to the display you see when you design a table? That is, column name, type and description -- I don't care about the other attributes at the moment. I know you can use the Documenter but I want the results as a table if possible. TIA, Arthur -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm