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!

Different Paycycles

Status
Not open for further replies.
crpjaviman

crpjaviman

Technical User
Jan 24, 2002
57
US
I am modifying one of my databases to compare the Weekday function results with our Payroll cycles. Here is an example:
Employee want to move a schedule from:
Previous schedule: Weekday results with a 5 (Thursday)
New schedule: Weekday results with a 7 (Saturday)

Payroll cycle is Saturday - Friday. Saturday being the first day of weekly cycle.

Employee cannot work this New schedule because it will fall on Saturday, but I need the database to recognize it.

I have tried some mathmatical solutions, but have not being able to make it work. I also have tried to use a Select function, but could not figure out how to compare them.

Any ideas on the problem?
 
Status
Not open for further replies.

Similar threads

puforee
  • Locked
  • Question
Using VBA to store a Access report to a local C: drive that works for different computers
Replies
1
Views
100
dhookom
dhookom
puforee
  • Locked
  • Question
Inport excel file with several different tabs 1
2
Replies
23
Views
353
Andrzejek
Andrzejek
dtay1132
  • Locked
  • Question
Run different queries based on value of Combo Box. 1
Replies
15
Views
226
dhookom
dhookom
kjv1611
  • Locked
  • Question
List out all different character types found in a table
Replies
14
Views
131
kjv1611
kjv1611
zevw
  • Locked
  • Question
Editing Table by looping through fields with different number
Replies
4
Views
53
zevw
zevw

Part and Inventory Search

Sponsor

Back
Top