W
wes k
i have 2 queries that share the fields "who" "when" and "amount". One
reports the value of daily labour (time out - time in * hourly wage) for the
employee (who). While the other shows the amount paid on a particular date.
When I create a query that includes these 2 queries and links the "who" field
between them I get a result that shows 5664 records where are only 260 when
you add the record count from the 2 queries that I'm using here. I'd like to
have a query that would report the amount owed out at any given time.
reports the value of daily labour (time out - time in * hourly wage) for the
employee (who). While the other shows the amount paid on a particular date.
When I create a query that includes these 2 queries and links the "who" field
between them I get a result that shows 5664 records where are only 260 when
you add the record count from the 2 queries that I'm using here. I'd like to
have a query that would report the amount owed out at any given time.