Calculated Fields

[techgurl]

I have a calculated field on my form that i am trying to get the results to be displayed my table also.

 

[Peter D]

Don't do it!

Sorry for the non-reply, but I must advise you to take a different approach.

Don't put the calculated field in your table or your form. Instead, create a query based on your table. Then add your calculation as a new field in the query. Then use this query as the recordsource for your form, and anywhere else you were using your table.

Hope this helps,

Peter De Baets
Peter's Software - Access Shareware and Freeware - http://www.peterssoftware.com

 

[Neo90815]

Someone had also suggested me not to do calculation on forms. The person suggested to put in the query.

How I have done it and it works is..

My Form is based on a query. In the query, I inserted calculation code, as described below, in the "Field" of the query.


**************
RespndTime: Format([DateTime]-1-[AckwldgTime],"Short Time")
*****************

RespndTime: ....means I'm crating a new field called RespndTime follow it is my code to do the calculation. After this is done in the query you can go to your form and drag and drop the new field onto your form from the Field List.

Hope this make sense. And yes, it will display on your table. I had the same problem. The results shows on the form but not the table.

Good Luck!


[This message has been edited by Neo90815 (edited 10-05-2000).]