M
mmike1053
I have already made 3 posts on this issue and have not
gotten a feasible/correct answer yet.
I have a database with 4 tables.
Table 1 has a single record for each employee.
Tables 2,3, and 4 have 1 record for each employee for each
month, hence 8 entries through August.
I want the single entry from table 1 with the summed
totals from tables 2,3, and 4.
I have an employee whose total in one field is 1 from
January. When I run the query he comes up with 64.
Everything in the query after the information from table 1
is multiplied by 64.
gotten a feasible/correct answer yet.
I have a database with 4 tables.
Table 1 has a single record for each employee.
Tables 2,3, and 4 have 1 record for each employee for each
month, hence 8 entries through August.
I want the single entry from table 1 with the summed
totals from tables 2,3, and 4.
I have an employee whose total in one field is 1 from
January. When I run the query he comes up with 64.
Everything in the query after the information from table 1
is multiplied by 64.