Make Table Query - inserting blank column

  • Thread starter Thread starter DBC
  • Start date Start date
D

DBC

Access 2000
Is there a way in a MTQ to insert a column that doesn't
pull info from the existing table and results in a labeled
column with no information in the new table?

Thanks!
 
Just type an expression into the Field row of the query design grid, e.g.:
SomeField: Null

The SQL statement will inlcude:
SELECT Null AS SomeField ...
 
Back
Top