tables fields

[funi.t]

hi
is it possible for one to let the user choose a certain number on their own without it being on the database?
Take for example i ask the user to enter a weight,and the user returns 50kg as the answer.i would like to take that weight and multiply it with the transport fee which is 789c/KG.

please help

[June7]

Certainly. Several ways to do it. This is basic access functionality and Access Help has guidelines.

1. Have user enter value into textbox on form. Have a calculation in another textbox that refers to other textboxes as terms for the calculation. Calculations also done in textboxes on reports.

2. Peform calculations in queries.

3. Access 2010 allows for calculations to occur in tables.

4. Other methods that involve code (macro or VBA).

[funi.t]

if i do it in a table and weight is not a field in the table but a value that the user should enter,how do i go about doing it?

[June7]

Can't do this directly with table. Table must have field. Can do it on a form. However, the weight entry won't be saved and when the form closes the weight will be wiped out.

Access Help has guidelines for building forms.

[funi.t]

okay .thanks a lot