Jump to content
Sign in to follow this  
Painturly

Student Question

Recommended Posts

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.

Share this post


Link to post
Share on other sites

Yes, you can do the math in SQL too. At the very start of the SELECT... so:

SELECT balance + paid FROM whateverTableWeAreTalkingAbout

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...