Field Size Calculated from Another Field's Value

[Etherington]

Hello,

Per the crude example, I'm attempting to format a report that will automatically sum the values from one column [TaskTime], and expand the field [Duration]in another column to suit the summed time (in 1 hour increments).


| Duration | Task Time | Task |
| (Hour) | (Hours) | |
| | .50 | Setup Tool |
| 1 | .25 | Load Part |
| | .25 | Run Part |
| 2 | 1.00 | Deburr Part |
| 3 | 1.25 |Assemble Part |
| | | |
| 4 | .25 | Inspect Part |
| | .50 | Package Part |


The [Duration]on the report can be an "unbound" field as the user DOES NOT enter data into the field. It will also always be in increments of 1-4 hours as shown.

The [TaskTime] is entered by a user and is Numeric data. [Task] is Memo data.

Possible?

Thanks.

Brad

 

[GShen]

Yes and no. I think it is possible but you would have to make 2 passes. You would have to create a table or temp table to sum up the data 1st and store it in a field (duration) and then on pass 2 you can you print your report.
You can't do it in 1 pass because there is no way for it to know what the sum is before you get there.
Hope that helps.

 

[Etherington]

Would I need to link the two tables with a common field and then create a report based on a query or a subreport. I've kind of stalled here with what to do.

 

[GShen]

Sorry for the delay, have been busy. I like to keep things simple. I would create another table with all the information you need (eg. duration, task time and task) and then use that table to generate the report.