W
wal50
There are three tables:
Employees: Each employee is assigned to a store and has a job code.
Multiple employees and job codes per store.
Closed Invoices this period identified by store
Open invoices this period identified by store.
I need to show:
1. Closed and Open volume counts by store. Have that.
2. Number of employees per job code in each store. Have that.
3. Number of open and closed invoices per person for each store. Don't have
that.
The only common information in the 3 tables is store number. I do separate
queries to obtain the first two rsults and was going to use a subreport for
#3. My issue is that I can't seem to get the results from the first two
together to do the simple calculation necessary. All the relationships are
many-to-many and the duplicate results are unuseable.
Any ideas are appreciated
wal50
Employees: Each employee is assigned to a store and has a job code.
Multiple employees and job codes per store.
Closed Invoices this period identified by store
Open invoices this period identified by store.
I need to show:
1. Closed and Open volume counts by store. Have that.
2. Number of employees per job code in each store. Have that.
3. Number of open and closed invoices per person for each store. Don't have
that.
The only common information in the 3 tables is store number. I do separate
queries to obtain the first two rsults and was going to use a subreport for
#3. My issue is that I can't seem to get the results from the first two
together to do the simple calculation necessary. All the relationships are
many-to-many and the duplicate results are unuseable.
Any ideas are appreciated
wal50