union query

[Khusro]

I made one table [check] with field ref,check#,date , details, amount(Dr), CR
and Clearance (Yes/No) for bank records

I Prepared two queries "Bank Balance"(Total) and "Book Balance"(Total) on
the basis of Yes/No field (if in Clearance, field "Yes" is "checked" it means
cheques has cleared from bank)

I want to combine both balances fron these two queries in one query showing
"bank balance" total and "book balance" total in one row. I tried to make
Union Query but only bank balance is appearing and second column showing
blank.

Please help me to create a query.

Khusro

 

[Steve Schapel]

Khusro,

I suspect that a Union query is not applicable here.

But, to help us better understand what you are working with there, could you
please go to the design view of your two existing queries, select SQL from
the View menu, and then copy/paste the SQL of these queries into your reply
here? Thanks.

 

[KARL DEWEY]

Post the SQL of both queries by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.