Multiple table query

[Shaba]

Hello,



I'm having some troble with a query that i am trying to create. let's say i have 30 tables that contain IBAN codes and the available balance of those accounts per day. the problem is that each day (table) has a different number of IBAN codes and if I only use relationships, the query will show me only the IBAN codes that are in the table 1 (day 1 of the month), all accounts added after day 1 being left out.
one of the solutions would be to use DLookUp but that would mean a very very long time to calculate the query.
Baisicly i'm trying to make a reunion of tables rather than a intersection.

Is there any other way to solve this issue?

Thanks

[orange]

What is the actual issue?
Why is there a separate table for each day? I can see how each day's transactions could be in a table, but I would try something like,
a) union the various day transactions, or
b) create a table and append each day's transactions to that table.

Here's a link to union query info.
http://www.techonthenet.com/sql/union.php

[Shaba]

There's a separate table for each day because each day a new report is generated automaticly, and the balances can differ from day to day.
The examples you gave me work just fine just that i didn't know how to do it.

Thanks!