Tricky Summary

[Lee J]

To all that help,

I have a field labelled "Qty" which serves two purposes based on the selection in a field called "Code" if the field "Code" is Time then the total will be "Qty" multiplied by the "Labourrate" field to give me a total.

If I select Material the total wil be "Qty" multipled by "ItemValue".

My problem is this I need to show a summary of Hours but because the Qty field is used for Time and Material I need to some how only total those in the "Code" Time.

Any ideas folks??

[Garry Claridge]

You could create a calculated field which outputs "Qty" if the "Code" is time, else "0". Then use this field for the summary.

Hope this helps.

Garry

[Lee J]

Cheers Gary,

I did think of this but was on sure what effect this may have on the system as I have several users entry data and I have heard that using Summary fields incorrectly can cause system slowdowns.

Thanks again

[Garry Claridge]

You can just use a calculation field with "Sum()" for each record. We use this type of calculation for quotes and invoices etc.

All the best.

Garry