Simple Formula Problem

[‹-cJr-›]

Note: All names and formulas in this post appear without the quote marks in the system

Hi.

I am sort of a n00b I uppose when it comes to MS Access. I never really used it before I started doing my A2 ICT coursework. My analysis needs to be in this Thursday and I also need to finish my tables and relationships; however I cannot continue if this formula keeps not working:

I have a field called "CostofQuote" and I am trying to get the value of that cell, divided by 2, to appear in another cell called "DepositPrice".

In the 'Default Value' text box of "DepositPrice" cell, I have tried many formulas and used the expression builder. Some formulas I have tried are "[CostofQuote]/2" "[CostofQuote] / 2", etc.

I keep getting the following attacted error messages, basically saying there is no field called "CostofQuote".

Please can somebody help me A.S.A.P? I would really appreciate it.

Thanks in advance,

‹-cJr-›

 

[JustinDB]

you need to use a som qeury in that query you can set the field witch needs to be devided in one of the field and put the code there. And than you co back to teh from and select the field from the query and TADA

 

[mamaw]

Are you trying to put the formula in the table or in a query?

 

[mikebaldam]

Query

This hopefully should help....

try using a query to do some maths for you... (or using wizard just type Deposit Price: [CostofQuote]/2 in as the field in Design View

or SQL View

Select YOURTABLENAME.[YOURFIELDNAME1]/2 As NEWTEMPFIELDNAME from YOURTABLENAME;

 

[johncallaghan]

I would put the following in the ON Current Event for your form where a txt_DepositField has Depositfield as it's source.

Enter
txt_DepositField = [costofQuote] / 2

the square brackets are optional.

I hope this helps.

Good Lick

 

[neileg]

All of the above answers are OK, but if you really are a beginner, you may not understand them!

You are trying to do something that is impossible, and bad design even if it was possible. Basically, you can't do calculations in a table. They have to be done in a query, a form or a report. Secondly, you shouldn't store the value of a calculation, you should calculate it when you need it.

A relational databse like Access is not a spreadsheet. You store your data in tables, you manipulate the data in queries, and display your data in forms or reports. In a spreadsheet, you store, calculate and display all in the same place.