R
reggie
i'm having trouble with a query and would really
appreciate some help:
i have a table with employee id's and names, i also have
four other tables with just the employee # and individgual
payments for ea district, those tables have multiple
entries for ea employee #, i trying to write a query that
will sum the totals for ea dist for ea employee. the
problem i'm having is that when the query is run, it
returns the same records over and over in the results.
where there is one pmt in a dist for an employee, it shows
that same pmt numerous times in the query. if anyone can
straighten me out, i'd be greatful
appreciate some help:
i have a table with employee id's and names, i also have
four other tables with just the employee # and individgual
payments for ea district, those tables have multiple
entries for ea employee #, i trying to write a query that
will sum the totals for ea dist for ea employee. the
problem i'm having is that when the query is run, it
returns the same records over and over in the results.
where there is one pmt in a dist for an employee, it shows
that same pmt numerous times in the query. if anyone can
straighten me out, i'd be greatful