How to make empty columns in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
I´ve neary managed to join 3 queries in a Union query, but one problems
remains.
The amount of columns is different between the 3 tables, and I would
therefore like to add empty columns to 2 of the queries.

How do I do that? I tried just adding without writing anything in them, but
they disappeared when I closed&saved the query.

Thanks!
 
Type in

Null As [ColumnName]

in the Union query where the columns are missing
 
You must log in or register to reply here.

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

Losing Records Between Union Query and Select Query 3
DSum in Query 3
dynamically choose columns in query 1
How to display multiple IIf results in one column 1
How do you ignore entire tables in an Inner Join Query? 13
Access #Error & Excel Pivot 0
Split data in field on character return 0
Union Query with division 2

Back
Top