formula value into table

  • Thread starter Thread starter rjejyork
  • Start date Start date
R

rjejyork

I have a form where I placed a field to calculate the number of days between
two date fields. I got the formula to work successfully but I want the table
to be updated with this value. I can't get that part to work. Help?

Thanks
Rachel
 
Is the table updateable, has the arrow and asterisk at the bottom
highlighted? Is the form editable. Are you using the formula as the control
source for a box? (like =datediff("d",[firstdate],[seconddate]) Are the other
fields on the form saving to your table? Do you have a command button to save
 
Yes, this table is updateable. I am using a formula as the control source
for a box and I do not have a command button to save on the form.

Golfinray said:
Is the table updateable, has the arrow and asterisk at the bottom
highlighted? Is the form editable. Are you using the formula as the control
source for a box? (like =datediff("d",[firstdate],[seconddate]) Are the other
fields on the form saving to your table? Do you have a command button to save
I have a form where I placed a field to calculate the number of days between
two date fields. I got the formula to work successfully but I want the table
to be updated with this value. I can't get that part to work. Help?

Thanks
Rachel
Click to expand...
Click to expand...
 
Did you create a field in your table to accept the new data and make the
field the correct datatype?

rjejyork said:
Yes, this table is updateable. I am using a formula as the control source
for a box and I do not have a command button to save on the form.

Golfinray said:
Is the table updateable, has the arrow and asterisk at the bottom
highlighted? Is the form editable. Are you using the formula as the control
source for a box? (like =datediff("d",[firstdate],[seconddate]) Are the other
fields on the form saving to your table? Do you have a command button to save
I have a form where I placed a field to calculate the number of days between
two date fields. I got the formula to work successfully but I want the table
to be updated with this value. I can't get that part to work. Help?

Thanks
Rachel
Click to expand...
Click to expand...
Click to expand...
 
Yes, I just can't seem to link the two together so when the formula gives a
value, it populates the field in the table.

Golfinray said:
Did you create a field in your table to accept the new data and make the
field the correct datatype?

rjejyork said:
Yes, this table is updateable. I am using a formula as the control source
for a box and I do not have a command button to save on the form.

Golfinray said:
Is the table updateable, has the arrow and asterisk at the bottom
highlighted? Is the form editable. Are you using the formula as the control
source for a box? (like =datediff("d",[firstdate],[seconddate]) Are the other
fields on the form saving to your table? Do you have a command button to save
on your form?

:

I have a form where I placed a field to calculate the number of days between
two date fields. I got the formula to work successfully but I want the table
to be updated with this value. I can't get that part to work. Help?

Thanks
Rachel
Click to expand...
Click to expand...
Click to expand...
 
That table IS the recordsource of that form and the field in the table? If
you go to your field list, that field in the table is in the list? That is
too weird. One question: do the other things you enter in the form get saved
in the table?

rjejyork said:
Yes, I just can't seem to link the two together so when the formula gives a
value, it populates the field in the table.

Golfinray said:
Did you create a field in your table to accept the new data and make the
field the correct datatype?

rjejyork said:
Yes, this table is updateable. I am using a formula as the control source
for a box and I do not have a command button to save on the form.

:

Is the table updateable, has the arrow and asterisk at the bottom
highlighted? Is the form editable. Are you using the formula as the control
source for a box? (like =datediff("d",[firstdate],[seconddate]) Are the other
fields on the form saving to your table? Do you have a command button to save
on your form?

:

I have a form where I placed a field to calculate the number of days between
two date fields. I got the formula to work successfully but I want the table
to be updated with this value. I can't get that part to work. Help?

Thanks
Rachel
Click to expand...
Click to expand...
Click to expand...
 
Yes, I just can't seem to link the two together so when the formula gives a
value, it populates the field in the table.
Click to expand...

Why would you want to do so?

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.
 
Back
Top