Calculating a Percentage

[pclutts]

I have a form (record source is table named tblBidTabs) with a field named PEREST. This value is the percent the low bid is over or under the engineer's estimate. The field name for the low bid is CNTRAMT, and the field name for the engineer's estimate is ENGSESTIM. Can I do the calculation somewhere in the design view of the table tblBidTabs or must I do it on the form itself? If on the form, should I write code associated with an event tied to the PEREST field? Could someone give me some detailed advise on my problem? Thanks in advance.

 

[PaulBricker]

You really should not store values for PEREST in your table. Create a query using your table tblBidTabs. Add all your fields and then use this as the Record Source for your Form. Then you can do the calculations right in the query if you want. You would just add a new column
PERESTENGSESTIM/CNTRAMTS)*100 or whatever your calculation is. Then any report or value in a Form you might need can be taken directly from the query.

Paul

 

[pclutts]

To PaulBricker: Thanks loads for the advise. It worked. Here's the formula I used; PEREST: (([CNTRAMT]/[ENGSESTIM])-1)*100