Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count weeks

Status
Not open for further replies.
rmiller11

rmiller11

MIS
Jan 20, 2003
43
US
We recently changed to a biweekly pay. Previously, I would count the paychecks in a quarter for Sate tax reporting. So now I need a way to count the weeks worked. It looks like DatePart would give me that info but I can't figure out the formula.

I already select the info by quarter and year. Our pay weeks are from Monday to Sunday. If they work any of the days with in that weeks then it counted as a week.
 
Sort by date Sort by votes
Never mind, I got it...

DatePart ("ww",{PRTran.TranDate} )
And do a running distinct count total

Thank you
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Group Sorting Distinct Count Minimum
Replies
2
Views
227
socalvelo
socalvelo
Paulo R
  • Locked
  • Question
CR Running Total distinct count duplicates
Replies
9
Views
331
Paulo R
Paulo R
ryanparks
  • Locked
  • Question
Grouping On Count of Records
Replies
10
Views
525
lbass
lbass
octaviz
  • Locked
  • Question
Avoid counting Line.Text with RecordNumber line numbers
Replies
4
Views
261
octaviz
octaviz
BradCustom
  • Locked
  • Question
Count or DistinctCount?
Replies
2
Views
97
BradCustom
BradCustom

Part and Inventory Search

Sponsor

Back
Top