Totaling unbound fields in reports

[ronaldff]

Hi!

I have a database table containing – among other data fields – 'name', 'task_date',. 'end_task_time' and 'start_task_time'

I would like to create a report showing 'name', 'task_date' and 'task_hours'. Decimal 'task_hours' is calculated from ('end_task_time' minus 'start_task_time') * 2.4

The report is to be sorted in date order and grouped by month, with monthly totals for 'task_hours'. Because 'task_hours' is calculated in an unbound field, I cannot see how to create the monthly totals – I could have done this by writing 'task_hours' back to the table and then using a bound field – but I understand that this is not good database practice (Thou shalt not…..!!!).

How can I get these monthly totals? You help would be appreciated

Ron

 

[pbaldy]

You are right not to store the value, but what I would probably due is base the report on a query that does the calculation. That gives you a bound field in the report that's easier to sum. Otherwise, you have to sum the calculation, like:

=Sum(Price * Quantity)

 

[ronaldff]

thanks - I have little experience with queries, but I'll have a go

ron