Would Someone please check this out!
Verify what I've done is correct!
Problem:
using format in an expression included in a Select statement it eliminates
the =S feature (doesn't sum)
Verified on the ConComp Database
Version 1.862xRT03 Windows
Example:
select Model,sum(Units)=S,sum(extprice)=S from TransDetail group by model
Model sum (Units sum (extprice)
-------- ---------- ---------------
CX3000 198 $319,900.00
CX3010 50 $95,550.00
CX3020 56 $89,275.00
MB3030 135 $284,750.00
MX3020 51 $89,500.00
MX3030 10 $22,500.00
PB3050 159 $368,000.00
PX3040 170 $399,250.00
-------- ---------- ---------------
829 $1,668,725.00
select Model,(format(sum(Units),'9,999.00'))=S,sum(extprice)=S from
TransDetail group by model
Model (format(sum(Uni sum (extprice)
-------- --------------- ---------------
CX3000 198.00 $319,900.00
CX3010 50.00 $95,550.00
CX3020 56.00 $89,275.00
MB3030 135.00 $284,750.00
MX3020 51.00 $89,500.00
MX3030 10.00 $22,500.00
PB3050 159.00 $368,000.00
PX3040 170.00 $399,250.00
-------- --------------- ---------------
$1,668,725.00
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
