[AccessD] make table query with empy fields

thanks a lot Doris, thats exactly what i needed

> 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
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail