-----Original Message-----
Clan,
Frankly, this is more difficult than it needs to be because of the
same category of data (pay status) being stored in 2 different fields.
Is there any chance of the table design being modified?
- Steve Schapel, Microsoft Access MVP
To clarify an earlier post, I'm trying to get the total
of two fields with like information, based on the
following table structure in my employee time clock
database:
tblSchedule
[EmployeeID] - joined to tblEmployees
[ScheduleTimeIn] - date/time, short time
[ScheduleTimeOut] - ""
[ClockTimeIn] - ""
[ClockTimeOut] - ""
[PayStatus] - Text from tblPayStatus
[AlternatePayStatus] - ""
I have a query behind the "time clock" form, with the
following additional fields:
[ScheduleTotal] = total of hours in schedule
([ScheduleTimeIn] - [ScheduleTimeOut]
[ClockTotal] = [clockTimeOut] - [ClockTimeIn]
[Difference] = [ScheduleTotal] - [clockTotal]
On monday an employee will call in sick all day, so the
[PayStatus] = "paid time off"
On Tuesday, the employee will clock in for say 5 hours
with [PayStatus] = "regular pay", then clock out sick
with the remaining 3 hours of [AlternatePayStatus]
= "paid time off".
How do a run a query that will combine the data from both
[PayStatus], [ScheduleTotal] and [AlternatePayStatus],
[Difference] to show that this employee has a pay summary
of:
Regular pay = 8 hours
Paid time off = 11 hours
Thanks!!!!!
Clan McCreery
.
