Jump to content
  • 0

Select Distinct Or...?


aam82
 Share

Question

I would like to report every other week on staff who worked. Each staff might have worked more than 1 hour, and each hour is booked individually.

 

report of who worked and how much:

staffname1 date hours

staffname1 date hours

staffname2 date hours

staffname3 date hours

staffname3 date hours

staffname3 date hours

etc

 

My ultimate goal is to email each staff once, by generating a report of just the staff person's email address IF they worked.

 

1. I don't know how to get a report that lists each staffperson *just once*.

 

2. Even if I did, I don't know a way to email them other than copy-pasting the names into email. Looking for automation here.

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Do you have a table that just contains the staff information where email is unique?  If so, base a report off that table, then use a calculated field along the lines of the following to get a sum of hours by that unique email. You could also place this in the details page of a report to get the hours from just that employee whose record you are in.

SELECT SUM(Hours) FROM Hourstable WHERE Email = target.[@field:Email]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...