Hi, i have written a report which is a summary of Adverts that appeared in a publication we produce, It has ADCount and costs etc, this works fine for a single year, hwever I need it to be a comparison, but when i setup the adcount formula it counts the ads for both years.
here are my two formulas
Year A
if {insertbk.dateins} in {?startdaterange} to {?stopdaterange} then
count ({insertbk.adnumbr})
Year B
if {insertbk.dateins} in {?startdaterangeb} to {?stopdaterangeb} then
count ({insertbk.adnumbr})
the field {insertbk.dateins} is the date advert appeared
the field {insertbk.adnumbr} is the Unique Ref for Advert
can anyone help
Simon
Edited by Simon Thorpe - 23 Nov 2007 at 1:00am