Painturly Posted February 24, 2013 Share Posted February 24, 2013 Hi: Painturly HereI am very new to this forum. I have an exam on Monday, yes tomorrow on Access SQL. I have a question that I have not been able to answer reading or through this website. Can SQL add the balance and paid columns of every record and show the result. Someone told me that I could not do that, that I would have to copy the table to excell do the math then import it back into Access.If anyone can answer this I would really appreciate it.ThankyouPainturly. Link to comment Share on other sites More sharing options...
boen_robot Posted February 24, 2013 Share Posted February 24, 2013 Yes, you can do the math in SQL too. At the very start of the SELECT... so: SELECT balance + paid FROM whateverTableWeAreTalkingAbout Link to comment Share on other sites More sharing options...
Painturly Posted February 24, 2013 Author Share Posted February 24, 2013 Thank-you so much for being so prompt.Painturly. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now