Thanks Ken! I got it to work perfectly! I didnt sort the records coming into the report though... I allowed them all to flow to the report, but then I limited each in the details section with the formulas, then subtotaled per account, then grand totals. I guess I was trying to do too much...
Okay, I see it now. The "if" formula that flags the record as true or false... that formula goes in the "details" section right? Then my subtotals, which appear in the group footer, will add up those details based on account number? I have not tried this yet... my database...
My company has purchased Best Software's FAS Fixed Asset Accounting package that utilizes CRW8. I want to create a report with 4 columns and records sorted by account number. Asset selection for each column will be different, but will all be based on 3 fields: acquisition date, disposal date...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.