V
vukas
hello,
I have 12 tables with common field "Employee Name" (duplicates OK). Every
table contains different type of records (salaries, bonuses, extra money and
etc.), every record has its own date and other variables.
I made one query for each table, which summarizes all records in numeric
fields (currency) for each employee according to many complex criterias. So
now I have 12 queries with "Employee Name" and "Total per employee".
How to get list of grand totals for every employee from these 12 queries?
These totals will be included to calculations in other queries.
Thank You!
Deivis
I have 12 tables with common field "Employee Name" (duplicates OK). Every
table contains different type of records (salaries, bonuses, extra money and
etc.), every record has its own date and other variables.
I made one query for each table, which summarizes all records in numeric
fields (currency) for each employee according to many complex criterias. So
now I have 12 queries with "Employee Name" and "Total per employee".
How to get list of grand totals for every employee from these 12 queries?
These totals will be included to calculations in other queries.
Thank You!
Deivis