Doing Maths Within Access And Saving From Excel

[Bobbles22]

Hi all,



This may be a really silly couple of questions, but I know Excel really well, but not Access.

Can I create a table within Access where I have a number of fields that are manually entered, and then some further fields which are populated following some maths function or even Excel function based on the data in that table or even data in other tables?

Also, I know how to open tables in Excel, but is it possible to save the entered data back into Access if I do some formula work on it?

Thanks

Bob

[June7]

Access 2010 introduced a Calculated field type in table design. It has limited understanding of intrinsic functions. Otherwise, build queries and do calcs in queries. Queries cannot reference Excel functions - VBA can.

You mean you know how to link Excel to Access table? I do not think edits of the data will automatically pass back to the Access table. Just as Access link to Excel cannot edit the spreadsheet. Requires VBA code either way.