I have created a database that tracks employee adherence. We have employees monitor adherence and when someone is out of adherence we track the time they are out and also there shift time. I am needing Access to know to change a record from 0:00 (midnight) to 23:59. I know it is probably done with an IF statement but dont know how to write it correctly, or where to place it.
Creating an If statement in a table
- Thread starter Cory356
- Start date
boblarson
Smeghead
- Local time
- Today, 02:33
- Joined
- Jan 12, 2001
- Messages
- 32,040
1. Tables store data - that's all (and all they should do)
2. You would need an update query to change all 0:00 to 23:59
3. You really don't need to do this if you store the date and time together as you can use the DateDiff function to gather the appropriate information.
2. You would need an update query to change all 0:00 to 23:59
3. You really don't need to do this if you store the date and time together as you can use the DateDiff function to gather the appropriate information.
