UNION QUERY NOT WORKING

i have created a field in a table that is based on (retrieves data) from two
different fields from two different tables. the table is working fine but the
form i have created based on the table fails to work properly with the
particular field.

the code is: "SELECT [DESCRIPTION] AS [liabilities]
FROM [IN-OUT-TBL] WHERE [TYPE]="DEBIT"

UNION SELECT [EXPENSES] AS [liabilities]
FROM [EXPENSES-MIX-FIX-TBL]

the error message i get when working with the form specifies that the code
contains punctuation errors and it is too long!

but why is the table working then?

pls give me a hint!

Angie

How did you do that? How did you get Access to retrieve data into one
table, based on other tables' data?

More info, please...

Jeff Boyce
Access MVP

"angie" wrote in message
...
i have created a field in a table that is based on (retrieves data) from
two
different fields from two different tables. the table is working fine but
the
form i have created based on the table fails to work properly with the
particular field.

the code is: "SELECT [DESCRIPTION] AS [liabilities]
FROM [IN-OUT-TBL] WHERE [TYPE]="DEBIT"

UNION SELECT [EXPENSES] AS [liabilities]
FROM [EXPENSES-MIX-FIX-TBL]

the error message i get when working with the form specifies that the code
contains punctuation errors and it is too long!

but why is the table working then?

pls give me a hint!