How to collect not related data in one window for viewing?

  • Thread starter Thread starter Vukas
  • Start date Start date
V

Vukas

I am creating a database for small business. There are many types of
expenses and incomes which will be entered in different days and periods, so
data can not be related in any way. My db has 17 tables.
How to create sole analytical window where user will be able to see
summaries and calculations of all data according to requested period of
time. I have done few queries for such summaries and calculations, but they
work with one table or with related tables only.

Thank You!
 
Well, you should probably find SOME way to relate your
tables, perhaps expense and income types? Otherwise, you
are going to have to create a very long, complicated union
query to gather all your table data together by dates.
 
Back
Top