I have read in past post there are some here that work with SQL. So this questions is for them.
First off let me say, I'm not a comupter expert by any means. What little knowledge I have is "self taught". I have built a few "DOS" data bases, some of which are still in use. But I feel it's time to look into a Window Data Base software. So, I am playing around with 2005 express (to use as a back end) and then some other software as the UI (any suggestion would be great!). Maybe with a little more time I could answer my own question, but no one ever said I was patience.
So, here's my question. Does SQL allow field calulations? Or is this all done in Scripts and Queries? In DOS a formula could be enter right into a field that would perform calulations based on information that had been entered into other fields. I have scanned thru a book, but never saw any reference to this.
Chuck