Access 97: Writing Calculating data to tables

[sabotaj]

i've got a few calculations for fields based on other fields. I've managed to run these calculations properly in Forms and they are stored in the formatasheet view, but not written to the underlying Tables. i there anyway i can create a bound field with calculations in a Form? any ideas please....urgent!! thanks

 

[Anne Troy]

Love your name.

Ok. Don't do the calcs on forms.

Do a query with your table fields. Add fields and create expressions for your calcs. Create the form based on the query instead of your table.

You don't NEED to store calcs in tables....that's the whole idea. All calcs are done "on the fly" (when you run the query, form, or report), so there's no need to store them in tables. You're just wasting space.

Understand?



Let me know.

 

[sabotaj]

Hey thanks for ya help, and the suggestion. Name is pretty alright huh? lol
I sorta found another way around it as well. because i'm builing a System for VERY basic users i have to keep the calcs in the form. What i've done is do an update query that initiates after the closing of the form- unfortunately this updates the entire table each time it is run. Any suggestions on that? But yeah- my basic problem is solved!!

 

[Anne Troy]

Yep. The only better name I can think of would be Self-Sabotaj. I used to do that a lot!

Anyway:

Just the same suggestion, Sab.

Whether you do the calcs on the form or not should not be making any difference to the user.

So either I don't understand what you're doing, or you don't understand what I'm suggesting.

I'm willing to look at your DB, tho.

Tools-Database Utilities-Compact and Repair, zip, ship to [email protected]