#1
|
|||
|
|||
programming question
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? |
#2
|
|||
|
|||
Re: programming question
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.
|
#3
|
|||
|
|||
Re: programming question
sweet. thanks
|
#4
|
|||
|
|||
Re: programming question
You can absolutely use SQL for this, and it should all be pretty easy
|
#5
|
|||
|
|||
Re: programming question
[ 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. |
#6
|
|||
|
|||
Re: programming question
You can probably also use a spreadsheet program like Excel as well.
|
|
|