total between two fields

[Clan McCreery]

Hello,

Below is my original post...in answer to Steve's
question, yes, my table can be changed....whatever it
takes to get these totals. Any ideas?

Thanks!

Clan McCreery

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

.

..