need easy soulution

[sougatau]

I have 1 table 'sum'

3 fields in it
'no1', 'no2' and 'add'

now have created 1 form with 3 text box

textbox names - 'text1', 'text2' and 'text3'

now I want when I will insert numbers in text1 and text2 then the summation will be shown in text box -'text3' -

the problem is -

I want to store the data which wll be displayed in textbox -'text3'

in the 'add' field of the table 'sum'


Thanks in advance
Sougata

 

[jesusoneez]

Quick Solution

If I'm right (and I might not be), you can't have calculated entries in a table...that's what queries are for.

You'd store "no1" and "no2" in table "sum" as suggested, then query table "sum", adding a calculated field within the query. Call the calculated field, "sum: [no1]+[no2]", and run the query.

So basically you are now using the query results as your source data as opposed to the table.

Now create a form using the form wizard...accept the defaults using the query as the source, and as you type numbers into the text boxes "no1" and "no2", it will update the "add" text box as you enter the data.

I enclose an example.

Also, if you really MUST have the "add" field in a table, you could use a make table query from the query example above, but I see no obvious reason for storing the results in a table unless you have something specific in mind...

 

[sougatau]

Hi many many thanks to u for helping me,
but I need the 'add' feild
Hope u wll help me again
Thanks

 

[sougatau]

ok, let me chk yr example 1st

thaks again

 

[Fear Naught]

Hi many many thanks to u for helping me,
but I need the 'add' feild
Hope u wll help me again
Thanks

Why do you need the add field? This goes against the principles of database design. All calculated data should be returned from a query for use in reports etc and not sotred in the database.