total days worked for individuals from different rows on a table

M

mwdmanjg

I have a database started with employees who worked different days in the
year, I need to make a report that pulls from the database and sorts the
employees in alphabetical order then totals the days they worked in the year.
The main database shows the day they reported to the jobsite and the day
they departed the jobsite under a job number main key on the table. the
problem i am having is that they may have left and returned on the same job,
and the query i'm making won't work because it says that there are duplicate
employees. HELP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top