Help with a Summary?

[rcorbitt]

I sell small ads in weekly newspapers in the Southeast US, and I need to generate a report (invoice) for each newspaper showing how many ads each advertiser ran during each week of the month. I have a file that includes five fields: Newspaper Name, Date, Advertiser Name, Number of Ads, Cost of ads.

Each time an ad runs, I create a new record. (Newspaper Name is a lookup from the related 'Newspaper Contacts' file.)

I created global fields (fDate1), (fDate2), (fDate3), (fDate4), (fDate5) to hold the date of each week, and I created a calculation field that compares 'Date' to "fDate1' and returns 'Number of Ads' when they match.

However, I am getting a result for every advertiser, and every date.

Advertiser

Invoice help.zip

[Robert Kidd]

Your summary report currently uses a body ( ie 1 per record ) not a sub-summary, see your file returned.

Tearsheets - Working COPY.zip

[rcorbitt]

Thanks! That works great!!!!