Mike & Doris Manning
mikedorism at adelphia.net
Wed Jan 7 15:31:58 CST 2004
Try it this way -- 0 AS [Insider Flag], 0 AS [Sex Code], 0 AS [Race Code] And replace the 0 with whatever default number you want... Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Oleg_123 at xuppa.com Sent: Wednesday, January 07, 2004 4:22 PM To: accessd at databaseadvisors.com Subject: [AccessD] make table query with empy fields How do I create empty fields in make table query ? I tried doing it this way -- [Expr1] AS [Insider Flag], [Expr1] AS [Sex Code], [Expr1] AS [Race Code], but this prompts me for what Expr1 is, also can I do it so it'l numeric field instead of text ? ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com