Software

Ask something
Question Locked

ms access 2003 forms

0 helpful
3 replies

by maphatsoe

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have created a form with calculated fields but the values are not stored in a table.
eg.(Total Cost =[Litres]*[price per litre])The answer appears on the form but not in a table can you please assist me with this matter

3 replies

by john.a.wills

Look at the data tab of the properties of the calculated field. I am not looking myself just this minute, but one of the properties should be "=me.litres * me.price"). Actually, I am a little hazy about what you want to do, and if I have not answered you adequately you should rephrase your question.

by sabine.nelis

Hi,

If you want to store the values in a table, you have to make fields in the table where you want to store the data. Than you have to put that field in your form and on the default-value of that field you write =[Litres]*[price per litre]

I hope this answers your question, so not just post again with more details.

Sabine

This discussion is closed to new replies.