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.