criteria in a table? not in a query is this possible?

[stafire_18]

I have a form that is entering information into a table. on that form is there away to calculate a field like if it were a query? so that when the record is saved the calculated field is saved also?

I know how to do this within a query but am not sure if it is avilable to do for a table?

 

[Norie]

You shouldn't really store calculated values in a table.

Any calculations should be done using queries.

 

[stafire_18]

but is it possible just for 1 field?

 

[Joe4]

Perhaps if we understand what you are trying to do and why, it will make more sense and we will be able to devise a good solution.

Why do you need it to write back to the table, and not use a query calculated field, like Norie suggested?

 

[stafire_18]

ok. i need a field to determin when the request was submitted (today) and how far it goes back. for example say a member is wanting to cancel their insurance policy back to 2/1/06. in a query i can have this calculated but then i'll probably have to create different tables to house allthe approvals/ not approved. if i can calculate this 1 field in a table then 1 table is all i'll need to house everything. i think i'm honestly looking too into this process... basic mdb. enter a record. go in & approve & save record. but i would like it to show how many days it will go back. your suggestions on what i should do. should i create different quieries to create a "approved" table & a "not approved yet" tables?

 

[Marbles]

Difference

If your really want to do it. In your table make a field called e.g. Difference. In your form make a textbox (called CalcDifference) that in the Query Builder, uses DateDiff("d",[RequestSubmitted],[CancelTo]).

Then in the After Update event of say the CancelTo field, Put Me.Difference = Me.CalcDifference. This will put the result in your table.

Whether it's any help, I'm not sure.

 

[stafire_18]

I'll give it a shot thanks!!!!