View Full Version : form calculations stored in table?


acd2
01-09-2002, 11:39 AM
i have several calculations that are being done on a form. i made each calculation a variable in my table beforehand. For example cs_avg. Then when designing my form, i dragged the var. cs_avg over to the form as a basic text box. used properties, control source, where i used the expression builder. the calculations all work just fine. but should the calc. results be ending up in the variable name cs_avg in my table? these calculations are dependent variables and my advisor would like to be able to extract these calc. into a program like SPSS. i have normally done all of my calc. in a stat. program like SPSS, never in my entry database so i am not sure how this works. any help is appreciated.

thanks,
angela

Rich
01-09-2002, 12:17 PM
You've basically given the reasons not to store the calculations. You can of course use calculations in a query, I believe you can export the query.