form values in table

ajitsingh

New member
Local time
Today, 12:39
Joined
Mar 21, 2010
Messages
2
hello i m new to access. i m using access 2007. my problem is that i m trying to get calculated values on form to table but it not being updated in table. however if i use split form with table it updates in the table under the form but does update in separate corresponding table.
:)
 
First, unless you are saving the results for historical purposes...you do not save results of a calculation. There is no need.
That being said, and if you really have the need to... a few ways to do it...
As you will find using this forum there are usually many ways to accomplish a task.... just whichever way suits you....
I prefer to do calculations in the query... For example, in the query grid you have your fields... Say... [Item] and [Quantity]... Next type into a blank space a new field title... Like.... Sale:[Item]*[Quantity] Now you have a new field "Sale" that is your result. Better to take it one step further and use Sale: (NZ[Item]*NZ[Quantity]) this returns any null values to zero....
Now you can pull this field onto any form...
I suppose you could put the calculation into the default value of a field in a table... but I don't.
Your field on the table could actually be named anything... Say "TotalSale"
Then in the After update event of the textbox (Sale) on your form.... you would put TotalSale = me.sale
 
thanx Curtis for the advise, as i have told i m new to access, yes i read somewhere that calculated fields are not saved in table. but my problem is i m trying to create a form in which i feed company name, bill no, bill date, basic rate, now are calculated fields, i.e. service tax(10% on 40% amount of basic rate), Education tax(2% of S Tax) and finally Total amount. now there are 10 different companies for which i enter above data.
once i have entered the data i need to have
one) companywise report of bill's
two) from certain bill no to certain bill no of particular company
three) monthwise companies bill details etc
presently i m doing this in excel but i wanted this to be littlemore automated.
any thoughts on above please help with it..
i m attaching my trial file for reference
regards.
 

Attachments

Users who are viewing this thread

Back
Top Bottom