PERFORMING CALCULATIONS WITH DATA FROM ACCESS 2000 DATABASE

[TNN]

I have an Access 2000 database with 12 tables. I want to write code to pull data from various tables in the databse, use this data to perform calculations, and then insert the calculation results in various other tables with reference to a primary key. I am using vb6.0 professional version.

A Thank You in Advance
[sig][/sig]

 

[bigfoot]

WOW what a request. If you are using VB6 just to copy the info and do the calcs, make this an Access application, and write it in VBA. It will be much cleaner.

Hope this helps ;0) [sig][/sig]

 

[TNN]

Thanks Bigfoot, but
Can't use access because need VB6 for other features of programm that also will have to access data base. Some of these will be add-ons to VB6 and are not available from access.

Thinking about using SQL for all of the mentioned above but not sure if feasible.

TNN, Tom

[sig]<p>TOM<br><a href=mailto:WWW.TNPAYROLL@AOL.COM>WWW.TNPAYROLL@AOL.COM</a><br>[/sig]