S
sunflare98
A union query I developed has suddenly stopped working. The syntax
is:
SELECT * FROM [myQuery - Part 1] UNION SELECT * FROM [myQuery - Part
2];
Pulling up each query individually works fine. When i run the above
union query I receive "Invalid use of Null". The number and order of
the columns in each query are identical. Access 2003 here.
Any ideas what could be the problem?
is:
SELECT * FROM [myQuery - Part 1] UNION SELECT * FROM [myQuery - Part
2];
Pulling up each query individually works fine. When i run the above
union query I receive "Invalid use of Null". The number and order of
the columns in each query are identical. Access 2003 here.
Any ideas what could be the problem?