My report reads a detail file and selects only records with a transaction date within a given date range. It also links to the matching header file and grabs a numeric field when the job# matches.... therefore not every header record in the file would be listed on the report. The selection works fine, but when I insert a Grand Total for the field that I got from the Header file, the value is greater than what the individual lines add up to on the report. I quickly did a report totaling that field for all records in the header file, but it did not match the number either. I need to total this field and tried many different ways... summing formulas, if/then/else, etc and I keep getting a number that doesn't make sense.
Is there a simple way to get a total for a record that is displayed on a report? Any help greatly appreciated!
Is there a simple way to get a total for a record that is displayed on a report? Any help greatly appreciated!