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

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!
 
M

mark

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Email data collection failure message 1
Using Collect Data with Related Tables 3
collect data from email in 2007 2
Access or Excel? 5
Saving collected data? 1
Avoiding Duplicate Entries 4
Merge a field data for all records in a table into one output 2

Top