[AccessD] make table query with empy fields

You want to add a new empty field or you want an existing field to not copy
the existing data? Is it just the one field or are you trying to copy the
table structure without data?

Susan H.


> 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
>