November 15, 200817 yr Newbies I am new to FM having come from DBase way, way back. I have constructed an FM database which, among other things has a numerical field which collects amounts of payments and an other field driven from a value list which indicates whether the payment was made by cash, cheque or credit card. Currently, the report totals all payment irrespective of type. I want to add some more fields on the report which break down the payment totals into Cash, Cheque or credit card. Something like sum for type = "cash" but I can't seem to find how to do it. I am sure there is a way - it would have been easy in Dbase. Any help to a newbie would be most appreciated. Many thanks, Peebs
November 15, 200817 yr Author Newbies Oops! Sorry. I should have read the banner and not posted a request for help here. My apologies Peebs
November 15, 200817 yr Author Newbies having apologised for incorrectly posting - just where does one post a request for help as a newbie?? Regards, Peebs
November 15, 200817 yr Welcome to the Forum. Set up a new layout in List Form. There is a wizard that will walk you through the grouping. Group by payment type. Set sort order to payment type and view in Preview mode. That should give you what you are looking for. If you have more questions let us know. For proper placement go to main forums page, chose the correct forum for your question and then add topic. hth Btw, it would be helpful to know what version of FM you are using and what OS. Edited November 15, 200817 yr by Guest
Create an account or sign in to comment