PDA

View Full Version : programming question


bobman0330
11-04-2005, 08:21 PM
I have some numbers in a database that i want to manipulate and sort. I have some basic c++ knowledge and i'm willing to buy a book and read it, if necessary. Three questions:
1) will MS Access allow me to manipulate database entries enough to satisfy my needs (find the largest entry of type x, multiply it by some other number, maybe some more sophisticated equations, nothing beyond that)?
2) Can i easily write c++ to modify access databases or extract data from them and modify it?
3) is there a free or cheap DB program that meets one of these criteria?

OrcaDK
11-04-2005, 08:32 PM
If i understand what you want correctly, you should be able to make those changes using SQL directly in access. No need for any 3rd party apps.

bobman0330
11-04-2005, 08:44 PM
sweet. thanks

Freakin
11-05-2005, 12:05 AM
You can absolutely use SQL for this, and it should all be pretty easy

CORed
11-06-2005, 03:03 PM
[ QUOTE ]
If i understand what you want correctly, you should be able to make those changes using SQL directly in access. No need for any 3rd party apps.

[/ QUOTE ]

SQL will probably work (depending on how complicated what you are trying to do is) If not, VBA (Visual Basic for Applcations) comes with Access and will enable you to do just about any manipulations you can imagine.

cgwahl
11-06-2005, 11:59 PM
You can probably also use a spreadsheet program like Excel as well.