calculation fron one table to another

  • Thread starter Thread starter mobeer1958
  • Start date Start date
M

mobeer1958

G-day
I am stetting up a database. I have built the tables and have them set in
one relationship. Now I would like to take a number from one colum and would
like to do a calculation and have that entered in another colum in a
different table. I am very new at this and know how to do formula's in excel
but my spreadsheet has gotten to big. So i decided to set up a data base. If
you can show me how to our know of any good online training where I can learn
how to do this. It would be appreciated.

Thanks
Dwayne
 
G-day
I am stetting up a  database. I have built the tables and have them set in
one relationship. Now I would like to take a number from one colum and would
like to do a calculation and have that entered in  another colum in a
different table. I am very new at this and know how to do formula's in excel
but my spreadsheet has gotten to big. So i decided to set up a data base. If
you can show me how to our know of any good online training where I can learn
how to do this. It would be appreciated.

Thanks
Dwayne
Click to expand...

I could give you a proper hint only: if there are no real reason,
don't store results of calculations in a table. You can always do the
calc on the fly.

If you insist on writing results into table then there are two ways.
As I don't know the structure of your database, I assume its possible
with Query, otherwise some VBA coding is needed.

Regards,
Branislav Mihaljev, Microsoft Access MVP
 
Back
Top