I'm at my wits end...

[nhoover]

I have a Time Sheet database i've putting together from barrowed (google) searches. Meaning I know crap about access and have learned my best once again to please my superiors. Please, if you could, take a look at my attached database. The source form is Work Hours, in which all the data is directly related. From there, I need to, at the moment, Report the non-billable hours by employee. You'll see the tables, forms, and reports. For some reason my Report is calculating very oddly. Sometimes certain hours for 'general projects' or 'property codes' will display, sometimes the hours wont. If you could help me i'd be more than greatful. Take care,



NateTimekeeper (2).zip

[June7]

Shouldn't every record in WorkHours have employee and work code?

The issue you describe is not manifesting with the data you provided. All records on report have hours as shown in table.

What do you mean by "hours for 'general projects' or 'property codes' will display, sometimes the hours wont" - how and where would 'general projects' and 'property codes' impact hours? Just what are you referring to by 'general projects' and 'property codes'?

[nhoover]

Well if you go over to the navigation pane, you'll see the bar titled for employee only. You'll notice that the form titled work hours is the base form which everything is pulled into to. If you open that form you'll notice on the header that you can run reports. The non billable hours is the only one i'm playing with at the moment. When I run this it only gives me hours from work codes (now labeled general projects). If I put in hours on my form from property codes, work in process, or equipment codes, they do not total in the non billable hours report. Just the Work codes/General projects total. Now, If I go into the design for the non billable report, my row source, now i'm assuming this, is pulling from a query. I don't think that information is correct in the query since adding the new fields, ie. property codes, work in process and equipemtn codes.

[June7]

Problem is your data structure is not normalized. All the codes should be in one table:

CostCodes
CodeID {primary key}
CodeType (Work, Property, Equipment, InProcess)
CodeDescription
Billable

Instead of separate fields in Work Hours for the codes, should be one field.

Then the two tables can be joined on the CodeID PK/FK fields.

[nhoover]

Thanks for the help. I think I figured out my problem.

One last thing, If you dont mind. In my non billable hours report, there is a subtotal and a total for hours. I'm trying to find a way to subtotal hours by the date. Meaning, If I work 4 hours in one code, and 4 hours in the next, it would bring up a subtotal for just that date...get me? Anyways, give me some feed back if you'd like. Still trying to figure out this whole access thing. Thanks again.

[June7]

Would need another group section for dates.