union all with Access developer extension

[Guest]

Hi all

I have some problems with an union query with ADE

It works fine when I run Access normally. But when I make a MDE file and
then run it, it fails. is there any problem using union queries? is there any
alternative way to using this kind of queries?

I have 2 tables: expenses and incomes. I make an union query to do
statistics, so, for example, if I buy a furniture and then sell it, I want a
record telling me the amount of purchase, the amount of sale and the
difference. There may be incomes and no expenses for some things, for
example, financial incomes. So the better way is unite both tables.

But it fails when running MDE. Any experience or idea?

Thanks a lot!

 

[Van T. Dinh]

Actually, incomes and expenses are different (sub-)types of transaction so
it may be better to use 1 single Table tblTransaction with 2 types of
transaction, e.g. income type and expense / out-going type. You can even
have more types of of transaction, e.g. income adj, expense adjustment ...

There is no problem with Union in MDE, AFAIK. I have a number of
applications with Union Queries in MDE and I have not had any problem with
Union Queries to date ...