Make Table Query - inserting blank column

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

Allen Browne

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text field in Access query is blank 8
Make Table Query, Question.... 8
Make table query: [Enter 1] AS Test 1
Query Table Properties 2
Losing information when running a query 4
Combine and Insert query 7
Alias outfield column header 3
Query to display highest totals 1

Top