Hello,

Help please

I have three tables with the following fields in them. Quarter 1 days, Quarter 2 days, Total days for quarter.

I would like to get the sum of qt 1 and qt 2 and have it applied to the total days for the quarter.

Your help is appreciated and thanks in advance.

I think you will need to describe your work a bit more. Does one table occurance (TO) have Q1D and the second have Q2D and the third Total or are all three in each of the three tables?. Are these fields summary or number fields?

If they are in one TO you can define a field as a summary field based on the fields you want to add. If they are in separate TO's you will need to use an intermediate field (ie a global) to carry and add the numbers by a script going from one TO to the other and then using set field to copy this sum to the total field.

I hope this helps.

You probably should not be using Quarter1Days, Quarter2Days. Instead have a field "Quarter" and put the correct value in it for each record and a seperate field for Days. But you may need to tell us more about what you are doing, as mentioned by Oldsneekers. It is almost always poor design to use fields SomeField1, SomeField2, etc because reports usually are hard to create.

Thanks for your reponses.

I tried this method and it seems to be working for me

(If they are in separate TO's you will need to use an intermediate field (ie a global) to carry and add the numbers by a script going from one TO to the other and then using set field to copy this sum to the total field. )

Thanks again this forum has never let me down

Don