difference between two numbers

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

difference between two numbers

Author

Message

Posted: 01/30/2002, 8:18 PM

Hey all, just started plating with codecharge again. First time on v2. It's nice. I have been racking my brains over something and I was hoping if you all could help. Does anyone know of a tidbit of code that will compare two numbers in a table or query and give you the difference between them? It's probably easy, I just don't know the specific function. Thanks.
J.

RFC

Posted: 01/31/2002, 8:38 AM

SELECT SUM(fldA - fldB) AS diff FROM table

should work

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login