dnowlan Posted September 19, 2000 Share Posted September 19, 2000 I have 2 databases: 1) a Project profile(contains project specific information ) and, 2) a budgeting database (tracks all invoices) I need to be able to show dollar totals on the "project profile" database by department. The buget database has a department field to differentiate the records and i have a relationship tied to project total. I cannot seem to get dollars seperated by department. i am lookig for a "Sum If" like command. Thanks! Link to comment Share on other sites More sharing options...
Vaughan Posted October 30, 2000 Share Posted October 30, 2000 Are you finilar with FMP's Summary layouts? Create a new layout. Delete the "body" and create a Sub-Summary part with "department" as the sort (break) field. Make a summary field in the database that is the total of the dollars. Sort the database by Department and Preview the summary layout. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8587 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now