Scott Pon Posted September 17, 2004 Share Posted September 17, 2004 I have a order entry database. The original programmer (a long long time ago, in a galexy far far away...) decided to use repeating fields (see another universe). One of the repeating fields is a part number. The objective is to write a report that will give the count of orders that use that part number. I have a field "Count of Orders" that is a summary count on "sales order numbers" I create a layout that shows the part number and order number. Then I have a Trailing grand summary that has the count. However that will only count the found records. So I tried to use the "subsummary when sorted by:" Part Number but that did not show ANY Counts. Did I do that wrong? Could the repeating field be screwing this count up? Thanks. Scott Link to comment Share on other sites More sharing options...
bruceR Posted September 18, 2004 Share Posted September 18, 2004 You have to get rid of the repeats. Get the design right and use orders/order items tables. Link to comment Share on other sites More sharing options...
LiveOak Posted September 18, 2004 Share Posted September 18, 2004 If the subsummary part doesn't show at all, make sure you are sorting by the field used in the subsummary (subsummary when SORTED BY). -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7323 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