stuck in design

[TC]

What are your tables?

What is the primary key of each table?

TC

 

[Clan McCreery]

Hello

I'm having a huge problem with my database and I think
its in my table design. I'm doing a "time clock"
database, and for each day that an employee works, I have
a [PayStatus] field which is linked to a query that runs
totals from the various time in, time out fields to give
me a total of hours based on the [PayStatus]. I created
an [AlternatePayStatus] field to categorize
the "difference" in hours between someone's schedule and
clocked time. Example, an employee works a regular day
so [PayStatus] = "regular pay", then they clock out early
for a docter's appointment, so the difference in time
between actual worked and schedule is
[AlternatePayStatus] = "vacation pay".
It was working great until I created the reports to show
total hours of each pay status category (i.e., how many
hours this pay period of "regular pay", etc.) and now I
can't combine the data between the two fields.
I've been told I'm making this harder than it needs to be
but I'm drawing a blank on how to collect this data into
one field.
Please help?

Thanks

Clan McCreery

 

[Clan McCreery]

I only have two tables, tblEmployee [EmployeeID],
tblSchedule [ScheduleID]. I'm assuming I need to break
out the pay status poriton from tbhSchedule, but I can't
figure out exactly, I'm drawin' a blank....

thanks!

-----Original Message-----
What are your tables?

What is the primary key of each table?

TC

Hello

I'm having a huge problem with my database and I think
its in my table design. I'm doing a "time clock"
database, and for each day that an employee works, I have
a [PayStatus] field which is linked to a query that runs
totals from the various time in, time out fields to give
me a total of hours based on the [PayStatus]. I created
an [AlternatePayStatus] field to categorize
the "difference" in hours between someone's schedule and
clocked time. Example, an employee works a regular day
so [PayStatus] = "regular pay", then they clock out early
for a docter's appointment, so the difference in time
between actual worked and schedule is
[AlternatePayStatus] = "vacation pay".
It was working great until I created the reports to show
total hours of each pay status category (i.e., how many
hours this pay period of "regular pay", etc.) and now I
can't combine the data between the two fields.
I've been told I'm making this harder than it needs to be
but I'm drawing a blank on how to collect this data into
one field.
Please help?

Thanks

Clan McCreery

.

 

[Steve Schapel]

Clan,

See my reply in .queries newsgroup.

- Steve Schapel, Microsoft Access MVP