is there any way to over ride a calculation field?

no only calculated results fields.

Update: To clarify, you can use fields with the option of calculated Value.

Edited January 12, 200620 yr by Guest
Clarification

well is there any way to set it up so that i have a feild that calculates when neccisary and still allows me to edit it if need be as well

That is what auto-enter calculations are for.

they only work once though....they don't continue to work as i need them too....i have several feilds that are teid to several date feilds, the date feilds are set up to be the current date and the next few days...the feilds under them represents values for those dates and when the date changes at midnight the dates carry over as needed but the other set of feilds do not, example

mon teus wed thrus fri

1.....3.....6.....2.....7

at midnight it needs to change to:

teus wed thurs fri sat

3......6.....2.....7...(default value for sat)

instead it does this:

teus wed thurs fri sat

1......3.....6.....2....7

the dates move properly but the vaules under don't, BUT the values can be changed at any time and if they are they must still carry over as is come midnight and the new date moving in at the end brings up a default value for the specified day

Only an unstored calculation field can change automatically with the current date.

If you still need to override that, create an override field, and change the calculation to something like:

Case ( IsEmpty ( OverrideField ) ; << default calc >> ; << override calc >> )

that would sorta work, but i have to be able to edit one of them manually not through a calc and the editing has to be done to he calculated value

EDIT:

the problem is that the default calc nad hte override field are the same field.

Edited January 13, 200620 yr by Guest