Populating

[Chris75 via AccessMonster.com]

Hello,

I'd like some help figuring out how to get the following scenario to work as
my efforts are not successful so far.

I have 2 subforms based on tables. One for schedules and the other for
productivity. Scheduling is done on a daily basis. Productivity is done on
a weekly basis. In the scheduling subform, I have one unbound field for
hours worked. The hours worked are calculated with a formula that returns
what I want (daily hours worked). However, in the productivity subform, I
have a field for hours worked, but this is for the week. The week starts on
Monday.

What I would like to do is have the two linked. Therefore, the weekly hours
totals that are populated in the productivity subform come from the totalling
of the daily totals for a particular week. I also want any changes made in
the hours worked in the scheduling subform to automatically appear in the
hours field in the productivity.

Any help?

Thank you!

 

[Jeff Boyce]

How depends on what, and I'm not quite clear on what your data looks like.

Please post your underlying table structure...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Chris75 via AccessMonster.com]

Hi Jeff,

The data is numerical. In quarter point format.

Ex: 7:15 = 7.25

I have 5 fields (Time In, Time Out, Time Off, Anomaly and Overtime). I also
have a WorkDate field. The calculation is : Time Out - Time In - Time Off -
Anomaly + Overtime = Hrs Worked

This occurs for each day worked.

I hope this answers your question.

How depends on what, and I'm not quite clear on what your data looks like.

Please post your underlying table structure...

Hello,

[quoted text clipped - 24 lines]

Thank you!

 

[Jeff Boyce]

Why are you separating time from date?

What are the datatypes of those fields?

You can do calculations in a query.

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Hi Jeff,

The data is numerical. In quarter point format.

Ex: 7:15 = 7.25

I have 5 fields (Time In, Time Out, Time Off, Anomaly and Overtime). I
also
have a WorkDate field. The calculation is : Time Out - Time In - Time
Off -
Anomaly + Overtime = Hrs Worked

This occurs for each day worked.

I hope this answers your question.

How depends on what, and I'm not quite clear on what your data looks like.

Please post your underlying table structure...

Hello,

[quoted text clipped - 24 lines]

Thank you!

 

[Chris75 via AccessMonster.com]

Hi Jeff,

Workdate and Time are separated in order to better calculate hours worked.
The format used in my place of work for time is decimal (7.5 = 7:30)

The datatype is numerical.

One thing I thought of is the following. Seeing as I have Workdate in my
schedule table/subform and Workdate in my productivity table/subform, would I
be able to use this field as a reference?

For example, I have entered the Workdates for this week (Nov 9 to 13) in
"Schedule", If I were to just enter the Workdate for Monday (Nov 9) in my
"Productivity", would I then be able to set up a query that would
automatically give me the total hours worked for that week in the
"Productivity" field labelled Hrs?

Thank you

Why are you separating time from date?

What are the datatypes of those fields?

You can do calculations in a query.

Hi Jeff,

[quoted text clipped - 21 lines]

 

[Chris75 via AccessMonster.com]

Hi Jeff,

Any ideas on the below?

I actually created a query for this before, deleted it and now can not recall
it again.

Thanks.

Hi Jeff,

Workdate and Time are separated in order to better calculate hours worked.
The format used in my place of work for time is decimal (7.5 = 7:30)

The datatype is numerical.

One thing I thought of is the following. Seeing as I have Workdate in my
schedule table/subform and Workdate in my productivity table/subform, would I
be able to use this field as a reference?

For example, I have entered the Workdates for this week (Nov 9 to 13) in
"Schedule", If I were to just enter the Workdate for Monday (Nov 9) in my
"Productivity", would I then be able to set up a query that would
automatically give me the total hours worked for that week in the
"Productivity" field labelled Hrs?

Thank you

Why are you separating time from date?

[quoted text clipped - 7 lines]