PDA

View Full Version : Is is possible to auto-calculate different fields from different tables using vba?



wedd
03-15-2011, 01:21 AM
Hi experts, I was wondering if it was possible to either write a macro or vba script or expression or sql script to calculate different fields from different tables to autopopulate on form? Is this possible? If so, how can this be done?


Thanks for your contributions:friends:

OBP
03-15-2011, 10:59 AM
Which method do you want to try first?
Do you want the data saved in a table?
The most obvious is a query, but for more complicated calculations VBA would be better.