Numpty Blank Query Column

Question

Hi all

I am looking to union some queries where the number of columns doesn't match.
Googling this gives responses generally in SQL/VBA which are not my forte.

Is there a way in the Access design window of introducing blank columns so that a union query will work?
Also, I am guessing that it would require different syntax if the blank column were unioning to a number column, text, date etc. column in the corresponding query.
Examples of the different types would be appreciated.

Many thanks

Phil

Answer 1

Hi,

How do you create a UNION query without using SQL or the SQL view? ;-)

Sure, you can also create the necessary/missing columns in the design window by writing sth like this in empty columns of the query grid:

myText: Null
or
myNumber: Null
or
myDate: Null

Where Null would be that you don't want to have a value in non existing field cases. You could also state a value of a fitting type instead of the Null.

Servus
Karl

---

http://AccessDevCon.com
https://www.donkarl.com

Answer 2

Hi Phil. In the query designer, just add a new column like:

Expr1: Null