Can someone please help me. I'm trying to do what I would call a group by in sql. I have multiple rows of fund codes with amounts for a person. I want to just show a total of the amount for each person (one row for a person). when I got rid of the fund code and kept the amount column and used a sum on the amount column....it didn't sum all fund codes. It only gave me the one amount(i think the first). how can i get a sum for each person. I'm doing a by on the name.

Kitten,

First things, first. Please update your profile signature with your product suite, releases, and platform. That way we can better help you.

Secondly, it sounds like you are doing it properly, i.e. SUM AMOUNT BY PERSON_NAME. BY is the WebFOCUS equivalent of GROUP BY and ORDER BY.

You might want to post your code (and your master if it is not too big). Maybe you've got a join going on that is skewing the results.

** Update signature
1) Logon to Focal Point and go into your complete profile.
2) Scroll down the page until you see the “Signature” field.
3) Fill in the signature you want to use. Here is a sample to model:

Member Name
Member Title

Prod: WebFOCUS 5.2.3 on Win 2K/IIS 6/ISAPI Mode
Test: WebFOCUS 7.1 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode

4) Once all changes are made/added, scroll down to the bottom of the page and click on the Submit button.

TABLE FILE AS_RESIDENTIAL_LIFE
SUM AWARD_TERM_ACCEPT_AMOUNT AS 'Accept Amount'
BY Name
PRINT
BLDG_DESC_ROOM AS 'Building'
ROOM_NUMBER AS 'Room No.'
MSCD_DESC AS 'Meal Plan'
BY Name 
BY TERM_CODE_KEY AS 'Term'
BY ID
ON TABLE SET BYDISPLAY ON
ON TABLE SUBFOOT
END