total for two fields

[Clan McCreery]

Hello

In my "time clock" database, each employee has a record
for each day worked, which contains two fields;
[PayStatus] which is related to the [TotalHoursWorked]
field and [AlternatePayStatus] which is related to the
[Difference] field...this field calcutates the difference
in hours from [TotalHoursWorked] and their regular
schedule, so if they go home early, the
[AlternatePayStatus] might equal "vacation pay" and the
[Difference] would equal the hours of "vacation pay".
Both pay status fields use the same categories, such
as "regular pay", "vacation pay", etc. from another table.

So, I need totals of categories, like how many hours year
to date of "vacation pay", but the info is coming from
two different fields and I'm drawing a blank on how to
combine this information into one total for each
category. I've tried crosstabs but still not getting a
combination of the two fields.

Thanks!!

Clan McCreery

 

[Ken Snell]

Could you give us a bit more details about the actual table structure and
fields? It's not clear to me from your description. Makes it difficult to
propose a query solution without knowing this info.