I have a database(Foxpro Win2.6) which has patient charges and pmts in "fee" field. Their account numbers are in field "acc_num". Some patients have only a few entrys,and others have several. I have a field named "balance",which I have been trying to place the sum() of each "fee" for each patient,but can't seem to get it right. Will appreciate any help I can get. Thank you in advance !
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.